Maybe something like this:
SELECT gid FROM A LEFT JOIN B ON A.gid = B.gid_fk WHERE gid_fk IS NULL
SELECT gid FROM A LEFT JOIN B ON A.gid = B.gid_fk WHERE gid_fk IS NULL
| Subject | Author | Views | Date |
|---|---|---|---|
selecting from 2 tables - left joins?
|
ryel01 | 1561 | May 25, 2005, 2:20 AM |
|
Re: [ryel01] selecting from 2 tables - left joins?
|
afinlr | 1432 | Jul 18, 2005, 2:29 PM |