I'm trying to make a query that will return rows of data from a table based on whether the row of data is unique in one column, Subject Line, and not a duplicate of another piece of data in that column.So my query would ideally return the rows with ID 1,2 & 3.
ID (Primary Key) Subject Line Attachment 1 Subject 1 Att1 2 Subject 2 Att1 3 Subject 3 Att2 4 Subject 1 Att2