G
Guest
Hi, need the help of the gurus again.. and the help is appreciated in advance
yet again.
I have a TableA with values RED, BLUE, YELLOW, GREEN and TableB with values
RED, BLUE. would like to obtain the result of TableA of those records that
are not in TableB. Answer would be: YELLOW, GREEN. (this is in lamest terms)
the actual SQL Statement being used is:
SELECT DFIDUIINFO.filename, DFIDUIINFO.createSel
FROM DFIDUIINFO, [UIL SelectDI filenames]
WHERE DFIDUIINFO.filename <> [UIL SelectDI filenames].[filename];
but it ends up giving me all the records on both tables.. again thank you
for your help..
-Sam
yet again.
I have a TableA with values RED, BLUE, YELLOW, GREEN and TableB with values
RED, BLUE. would like to obtain the result of TableA of those records that
are not in TableB. Answer would be: YELLOW, GREEN. (this is in lamest terms)
the actual SQL Statement being used is:
SELECT DFIDUIINFO.filename, DFIDUIINFO.createSel
FROM DFIDUIINFO, [UIL SelectDI filenames]
WHERE DFIDUIINFO.filename <> [UIL SelectDI filenames].[filename];
but it ends up giving me all the records on both tables.. again thank you
for your help..
-Sam