Subject | select etc. |
---|---|
Author | Michael Vilhelmsen |
Post date | 2003-03-18T10:57:59Z |
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 ?
Regards
Michael
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 ?
Regards
Michael