Re: SQL Select Question

[Beverley Childs <bdc@MFLTD.CO.UK>]

If I understand the problem correctly, I think the following will work:

select tablea.* (or list of columns) from tablea, tableb  where tablea.key
!= tableb.key

                -----Original Message-----
                From:   C. Duncan Hudson [mailto:c_duncan_hudson@YAHOO.COM]
                Sent:   09 July 1998 15:34
                To:     Multiple recipients of list SQR-USERS
                Subject:        SQL Select Question

                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