SQL Select Question

["C. Duncan Hudson" <c_duncan_hudson@YAHOO.COM>]

I realize that this is really an SQL question, and not an SQR question
but I was hoping that with everyone's expertise here I could get a
quick (and satisfactory) answer.

Here's my question.  I want to create a report that selects about 10
columns from a single table.  The selection should be based upon field
values within that table.  Also (and here's where I'm having
problems), I need to look at another table to see if the first table's
primary key is represented in it.  If it is, I want to exclude it from
my selection.  Do you follow that?  Here's a crude visual:

TABLE A                 TABLE B
100                     98
101                     100
105                     108
107                     110
110
111

In the above example I would want to select 101, 105, 107 and 111 from
Table A.  Can anyone give me a hand?  Thanks in advance,


Dunc.




_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com