Simpel delete

Jeg prøver at bruge følgende sql:

strSQL = "DELETE FROM oenskeliste WHERE id NOT IN (SELECT oenskeliste.filmid, oenskeliste.id, video.FilmID FROM oenskeliste, video WHERE oenskeliste.filmid=video.FilmID;);"
Conn.Execute(strSQL)


Men får følgende fejlbesked:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.


hjælp