Have a table with 3 columns. ID, Main and Sub1 I want to write a query where it will select strings in the Sub1 column if the Main column is unique. So for example text in Sub1 can be the exact same word but the word in the Main column is different and it will show both records. Please see pic enter image description here
