Select rows for values in one table but no in another

[Pika Varsh]

Hi there,

I have 2 tables transactions and dealer. for each record in the transaction tbale (i.e. for each transaction created) there is a dealer_code (dealer_code being the primary key of dealer table where details of all dealers are kept) assigned to it. I want to get a list of all dealers that are in the dealer table but not in the transactions table for the month of June. I have used the following but it doesnt work! Help!


Select dealer.DEALER_CODE, dealer.DEALER
From dealer , transactions
Where month(transactions.TRANSACTION_CREATED) = 6 AND dealer.DEALER_CODE <> transactions.DEALER_CODE


This gives me all the dealers in the dealer table and not those not found in the transactions table.