Re: SQL Select Question

[Richard_Tomancik <Richard_Tomancik@TIGINSURANCE.COM>]

Try This

select
a.field_1,
a.field_2,
...
from table_a a
where not exists
    (select 'x'
      from table_b b
     where b.field_1 = a.field_1)

Usually works for me.

Richard Tomancik
richard_tomancik@tiginsurance.com
817/975-1892





"C. Duncan Hudson" <c_duncan_hudson@YAHOO.COM> on 07/09/98 09:34:22 AM

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Richard Tomancik/Consultant/Dallas/TIG)
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