SQL Select Question -Reply

[Wes Williams <wwilliams@MAIL.RKD.SNDS.COM>]

Hi Duncan, you can do an outer join

example
SELECT
  table1.col1,
  table1.col2,
  table1.col3
FROM
  table1,
  table2
  WHERE
  table1.col1 = table2 .col1 (+) and table2.col1 is null


Hope this helps


Wes Willaims

>>> "C. Duncan Hudson" <c_duncan_hudson%yahoo.com@internet.rkd.snds.com> 07/09/98
09:34am >>>
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