我有一个SQL查询问题。问题出在IN ....
,但我不知道如何解决。这是查询:
SELECT *
FROM Reports, Games, Developers
WHERE Game = SpelID
AND Developer = IDDvl
AND Land IN[‘Japan’,‘USA’,‘UK’,‘Indië’,‘Duitsland’,‘Zweden’]
这是错误消息:
An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in System.Data.dll
In operator without () in query expression 'Game = SpelID AND Developer = IDDvl
AND Land IN [‘Japan’, ‘USA’, ‘UK’, ‘Indië’, ‘Duitsland’, ‘Zweden’]'.
dagoederen = New OleDb.OleDbDataAdapter("SELECT * FROM Reports , Games,
Developers WHERE Game = SpelID AND Developer = IDDvl AND Land IN (‘Japan’,
‘USA’, ‘UK’, ‘Indië’, ‘Duitsland’, ‘Zweden’)", connectie)
您需要更换[ ]
与()
后IN
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句