Subject Re: [firebird-support] SQL Select Joins Syntax
Author James

Kevin Stanton wrote:

> Greetings,
> I am currently joining:
> select [field list]
> from Table1 T1
> left outer join Table2 T2 on T1.ID = T2.ID
> This gives me everything in Table1 whether or not it exists in Table2.
> What is the best way to find out what is in Table2 that is not in Table1.
> Thanks,
> Kevin

Try this if it will work

select [field list]
from Table2 T2
where not exists (select * from Table1 T1 where T2.ID = T1.ID )

This will display all the records in Table2 that is not in Table1 I
think ...