[Resolved] SQL Question

[Hotkey]

Hi there,

i've got the following question :

I have two tables like the following :

table1:
ID | Name

table2:
scndID | moreInfo

Now i want to have a select which returns me every row from table1 whose ID value is NOT existent in the 'scndID' collumn from table2.

I thought i can do this with an inner select but all i get is an error.

I've tried the following :

SELECT Name,ID FROM table1 WHERE ID NOT IN (SELECT scndID FROM table2)

Im using mysql 3.25 on winXP ....

Thanks in advance for your help !

[petitduc]

MySQL doesn't support subqueries below version 4.1.
As explained in the mysql manual, subqueries can be replaced by outer joins :

Try this :

SELECT * FROM table1
LEFT JOIN table2
ON table1.ID=table2.scndID
WHERE table2.scndID IS NULL

[Hotkey]

Hey great ! That did the trick !

many thanks !

-> solved