Looking for a non existing records

[dominant]

I have 2 tables, and i want to check if a record reference of the first table exist in the second.

I something like that table1.field != table2.field

[Weedpacket]

That's nice. The documentation for your database server doesn't mention joins?

[dominant]

Is the JOIN what i need. I thought JOIN was for joining sql statement with the same number of rows of resultset