Re: SQL Select Question

[Raghuram Chittari <Raghuramc@MASTECH.COM>]

Duncan ,

                Use a subquery in your select statement :

                Select
            col1,
              col2 ,
        col3
        ...



        from Table A
        where col1 not in  (Select col1 from Table B)




Raghuram c
Have a Good Day !!


        ----------
        From:  C. Duncan Hudson [SMTP:c_duncan_hudson@YAHOO.COM]
        Sent:  Thursday, July 09, 1998 10:34 AM
        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