Query with certain criteria

[Mike]

I have the following information:

I have a table with the following fields: store #, date, transaction #,and
line #(whether it was paid, taxes involved, markdowns). There are repeated
transaction #'s becaue of the different line #'s. For example:

Store # Transaction # Date Line #
060159 542596 09/02/09 MRD
060159 542596 09/02/09 TXS

I wanted to be able to create a query saying that if the store #/transaction
# does not have a line # of MRD, bring back only that information.

Thanks in advance.
Mike

 

[Douglas J. Steele]

SELECT StoreNumber, TransactionNumber, TransactionDate, LineNumber
FROM MyTable
WHERE StoreNumber NOT IN
(SELECT DISTINCT StoreNumber
FROM MyTable
WHERE LineNumber = "MRD")