not exists [message #39701] |
Fri, 02 August 2002 10:32 |
Sean
Messages: 22 Registered: July 2000
|
Junior Member |
|
|
I am trying to perform a delete on one table of any rows where columnA does not exist on another table in columnB. I can't seem to get it working...any advice?
|
|
|
|
Re: not exists [message #39705 is a reply to message #39701] |
Fri, 02 August 2002 11:18 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
There has to be some value in the column list - it could be NULL, a constant (1), any column(s) in t2. The actual value is irrelevant since the NOT EXISTS is just checking for a result set with no rows. It doesn't care what values are in the rows.
|
|
|