Re: SQL Statement

From: rok <rthumsi_at_cncx.com>
Date: 06 Aug 1998 23:33:14 PDT
Message-ID: <01bdc1cd$569b0ba0$32b59bcf@thumsi95.cncx.com>

How about:

(select * from tableA
minus
select * from tableB
)
union all
(select * from tableB
minus
select * from tableA
)

hi_wean_at_yahoo.com wrote in article <35c959c7.14819231_at_nntp.jaring.my>...
> Hi world,
> I have some sql stmt problem. If I have 2 tables, ie application and
> applicant.
> How to write a sql statement to select the records that do not exist
> in both tables ?
>
> Thanks in advance!
>
> V
>
>
Received on Fri Aug 07 1998 - 01:33:14 CDT