SQL query prblem

I am trying to execute the following query to find all matches not
listed in the kuponglinje table:

SELECT matchID
FROM matches
WHERE matchID NOT IN
(SELECT matchID FROM kuponglinje ORDER BY matchID)


For some reason this gives a syntax error. Anyone
got a suggestion?

Thanks.

 

 

 

 

Top