Re: Exclusive Query

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 09/10/04

  • Next message: mariela_montero_at_ncsu.edu: "Server identifier" 
    Date: Fri, 10 Sep 2004 06:03:19 +0530

    Try:

    select id from table1 a
    where not exists
    (select * from table2 b
     where a.id = b.id) 

    -- 
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com
  • Next message: mariela_montero_at_ncsu.edu: "Server identifier"