Re: SQL join to identify missing records?

Dear Susie,

   How are you I ahev got a solution of your problem

What I understand is that you have two tables , table1 and table2,

these both tables are joined. Suppose they are join by the field "id", that is id exist in both tables , then you have to select records which not exist in table1 and does not exists in table table2 , then a simple solution is followin command.

select * from table1
where id not in (select id from table2);

I think this command will solve you purpose.

Faheem Jabbar

In article <8o25cv$a4i$1_at_nnrp1.deja.com>,   Susie Grace <hlng_at_usa.net> wrote:
> I have 2 tables that are joined, and want to identify records that are
> in table1 but NOT in table2?
>
> What is the sample syntax?
>
> Thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 24 2000 - 07:03:24 CDT