Compare Two tables
I have two tables.
First table is just list of dealers (table name dealers)
Second table is user input of dealers transactions.(Table name is log) The first field of table two is the dealership name (field name is dealership).
Sometime not all dealers in the first table perform transactions.
How can show the dealers that are listed in the first table that are not listed in the second table.
I tried this, but it did not work
select dealers from dealers, log where dealers != dealership
Subject
Written By
Posted
Compare Two tables
June 13, 2005 12:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.