| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
09-28-2006, 01:20 AM
|
|||
|
|||
Oracle dialect question:
Does Not Exist?Table cp has primary key cp.id. In Table su, su.pid is a foreign key pointing to cp.id. However, not every record in table cp necessarily has an entry in table su. That is what I am looking for-all records in cp that don't have an entry in table su. Can somebody help me with the sql for this requirement?
Thanks     
|
 |
| Thread Tools | Search this Thread |
| Rate This Thread | |
|
|
