hi all
i have 2 transaction table... code is a common field for both the tables, what i need is a sql query to compare and list out the codes which are not present at the both the tables, replies will be help ful
cheers
parthi
Printable View
hi all
i have 2 transaction table... code is a common field for both the tables, what i need is a sql query to compare and list out the codes which are not present at the both the tables, replies will be help ful
cheers
parthi
SQL CODE:
This will work only if there is atleast one row in both tables. Modify it as per your wish. You can also give table1.code or table2.codeCode:Select * from table1, table2 where not table1.code=table2.code
Not really sure if I follow your question, but try using the
INNERJOIN parameter in your SQL query.