Topic: sql query
I have a small problem here, im not sure if its just because its monday or if it really is tricky but i shouldnt be to hard?
I have 2 tables, the first table has alot of rows and got a uniqe id-number.
the other tables contains one column with some numbers matching table1´s idnumber.
Now i want to select all rows in table 1 that does not have a matching number in table 2.
What i want out of this is:
Table 2 can also be completly empty.