> Hi
>
> 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 * FROM MYTABLE1 WHERE MYTABLE1.MYFIELD1 NOT IN (SELECT MYFIELD1 FROM
MYTABLE2)

HTH

Xavi.

>
> Regards
>
> Michael
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>