Find all in A that are not in B

[Adam Gerson]

I have two tables

Table A
id
Name
Table B
id
Name

I would like to pull all the records from table a that do not exist in 
table b

I tried adding a relationship between the id columns with the not equals 
sign, but that didn't work.

Any advice?


Thanks,
Adam



--
Adam Gerson
Assistant Director of Technology
Apple Certified System Administrator (ACSA)
Columbia Grammar and Prep School
phone. 212-749-6200 ex. 321
fax.  212-428-6806
[EMAIL PROTECTED]
http://www.cgps.org
Public key - subkeys.pgp.net