Subject Re: [ib-support] select etc.
Author Helen Borrie
At 10:57 AM 18/03/2003 +0000, you wrote:
>Lets say I have two tables.
>They are linked via MyField1 which i allocated in both tables.
>Table1 contains 100 records and table2 contains MAX 100 record (one
>per record in table1).
>In this exampel table 2 contains 25 records.
>Can I make a select statement, that will select those 75 records from
>table1 one, that DOES NOT have a corresponding record in table2 ?

select t2.MyField1, t1.*
from table1 t1
outer join table2 t2
on t1.MyField1 = t2.MyField1
where t2.MyField1 is null