> I have to tables, one containing the folowing records
> 1,2,3,4,5,6,7,8,9  and other with these 1,3,5
> How can I do a Query that gives me the records in first
> table that ARE NOT present in the other one.

> Beforehand, thank you very much.

>-----Original Message-----
>Assume in table1's field1 has value 1, 2, 3, 4, 5,... in
table2's field2 has
>value 1, 3, 5, ...use this SQL Statement:

>SELECT table1.* FROM table1 WHERE table1.field1 NOT IN

>FROM table2)

message

>> I have to tables, one containing the folowing records
>> 1,2,3,4,5,6,7,8,9  and other with these 1,3,5
>> How can I do a Query that gives me the records in first
>> table that ARE NOT present in the other one.

>> Beforehand, thank you very much.

>.