Selecting records not present in another table
Posted by:
mysql
Date: May 27, 2005 12:05AM
Hello
I have one table containing itmes each having its own id, and a another table containing some of these numbers in one of its columns.
I need to to build a query that returns the itmes from the first tables whose numbers are not present in the second table.
(SELECT t1.* FROM t1, t2 WHERE < the value in t1.item_id is nowhwere in t2.item_id >)
How do I do that?
Subject
Written By
Posted
Selecting records not present in another table
May 27, 2005 12:05AM
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.