>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