I flubbed the query I just posted.....
should be:
SELECT letters
FROM table1
WHERE letters NOT IN (SELECT letters FROM table2)
sorry ;)
Bryan Love ACP
[EMAIL PROTECTED]
-----Original Message-----
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 2:05 PM
To: CF-Talk
Subject: RE: select records from table 1, that are not in table 2 ?
try this, but be prepared for a slow query if the rows aren't indexed or if
the tables are big:
SELECT letters
FROM table1
WHERE pKey NOT IN (SELECT letters FROM table2)
Bryan Love ACP
[EMAIL PROTECTED]
-----Original Message-----
From: Vano, Carl G, SITS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 1:20 PM
To: CF-Talk
Subject: SQL: select records from table 1, that are not in table 2 ?
How would I select only the records from table 1, that are not in table 2.
1 2
A A
B B
C C
D
E
F
expected query result:
D
E
F
Thanks!
Carl
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
