need a sql query

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:

Code:

---

Select * from table1, table2 where not table1.code=table2.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.code

Not really sure if I follow your question, but try using the
INNERJOIN parameter in your SQL query.