Multiple entries - maybe wrong logic

[memkam]

SELECT DISTINCTROW T.ID, T.CustomerAccountNumber
FROM TransactionReport T, UCustomerNumbers AS U
WHERE T.CustomerAccountNumber<>U.CustomerAccountNumber;

For every record in the Transaction report, I want to ensure that a matching CustomerNumber was found in the U table. I am trying to list all the IDs in the Transaction Report table that did not have a matching CustomerAccountNUmber in the U table.

multiple IDS can have the same Account Number.

My code is listing all the instances of the transaction report table where the ID does not match - in essensce its an infinite loop - because even if the customeraccount number matches with ID1, it may not match with ID 2. WHich is OK. As long as all the IDS in the transaction report had a matchng customer account number. I could be way off over here.

Thanks for taking the time to read this!

 

[lespaul]

SELECT DISTINCTROW T.ID, T.CustomerAccountNumber
FROM TransactionReport T
WHERE CustomerAccountNumber not in (select CustomerAccountNumber From UCustomerNumbers);


Leslie

 

[memkam]

Thanks Leslie! worked like a charm.

 

[lespaul]

no problem!

Leslie