Re: SQL Select statement question ...

or how about

select key from tabA
MINUS
select key from tabB

(if key is in fact not a primary key you'll need some distincts in there).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Robbert Van der Hoorn" <rvanderhoorn_at_wanadoo.nl> wrote in message
news:3dcc226f$0$10856$8fcfb86b_at_news.wanadoo.nl...


> This is another way:

>

> select distinct a_key

> from

> (select a.key a_key, b.key b_key

>  from tableA a, tableB b

>  where a.key = b.key(+)

> )

> where b_key is null

>

>

>

> "Martin Doherty" <martin.doherty_at_elcaro.moc> schreef in bericht

> news:SeJy9.4$x86.354_at_news.oracle.com...

> > One way is with the NOT EXISTS predicate:

> >

> > select *

> > from tableA

> > where not exists (select 'x' from tableB where tableB.key = tableA.key)

> >

> > Yasuki Izaki wrote:

> >

> > >I'm looking for a sample SQL statement to select KEY field from tableA

> > >where KEY field does not exist in tableB?

> > >Lets' say, there are 2 tables (tableA and tableB). Both tables has KEY

> > >column defined. I need to know the records which KEY does exist in the

> > >tableA but does not exist in the tableB. What's the way to do this?

> > >Please e-mail me your suggestions to yizaki_at_yacan.com

> > >Thank you in advance for your hellp.

> > >

> > >

> >

>

>