Re: SQL Statement

From: Ivan Bajon <ib_at_ed.dk>
Date: Thu, 6 Aug 1998 10:45:56 +0200
Message-ID: <6qbq95$f9k$1@news1.tele.dk>

Taking for granted that the two tables are equal in their structure, this is a way to do it:

(select * from table1
union
select * from table2)
minus
(select * from table1
intersect
select * from table2)

Ivan Bajon

hi_wean_at_yahoo.com wrote in message <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 Thu Aug 06 1998 - 03:45:56 CDT