>>Hello!
>>I was just wondering if i can write a query that selects all the data not found in another table. like
>>select *
>>from table
>>where 100 is in one table... but not in the other table
>>?
>
>

select * from table1 where myField not in (select myField from table2)

>Cetin
oh thanks~!
u >all