[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
SQL Select Question -Reply
I'm referring to SAMS Publishing's "Teach Yourself SQL in 21 Days" (my
bible)...
You will probably need to employ the keyword EXISTS (pgs 139-142) in
your select statement. I'm not exactly sure of the syntax, but it will
probably look something like...
select A.field
from TableA A
where not exists
(select B.field
from TableB B
where A.field = B.field)
This is only a somewhat educated WAG. Good luck!!