Re: New-Bie SQL Question...

From: Ron Harvey <rbharvey_at_worldnet.att.net>
Date: 1998/05/07
Message-ID: <35527924.0@news3.uswest.net>#1/1

The following will select the rows in the first table that are not in the second table:

   SELECT * FROM TABLE 1
   WHERE NOT EXISTS
   (SELECT 'ANYTHING' FROM TABLE2
   WHERE TABLE2.COMMON_COLUMN = TABLE1.COMMON_COLUMN); Bhavesh Gosar wrote in message <6isqc6$7fv$1_at_engnews2.Eng.Sun.COM>...
>Hi,
>
>I have 2 tables (similar with 10 fields each...)
>each one has around 500K Rows with the second one
>having 100 Rows extra....
>
>How do I find the 100 Rows which are extra in the 2nd table
>using one SQL...??
>
>TIA,
>Bg
>
>
Received on Thu May 07 1998 - 00:00:00 CDT