hi again all,
this is the first time that i do a subquery on an access 2002 database and i am stuck with this syntax error...
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in query expression 'mmorpg.lng_id EXISTS IN (SELECT * FROM servers WHERE servers.lng_id IN (SELECT * FROM credits WHERE mmorpg.lng_id = credits.lng_rpgid AND credits.lng_userid = 23))'.
/rpgcasino/scripts/functions.asp, line 931
Code:
931: gwRS.Open SQLStr, gwConn, adOpenDynamic, adLockOptimistic, adCmdText
the sql string is as follows:
Code:
SQLStr = _
"SELECT * FROM mmorpg " & _
"WHERE mmorpg.lng_id EXISTS IN " & _
"(SELECT * FROM servers WHERE servers.lng_id IN " & _
"(SELECT * FROM credits WHERE mmorpg.lng_id = credits.lng_rpgid))"
once again, any swift help asap would be greatly appreciated.
Sincerely,
Pierre du Toit.
__________________
Sincerely,
Pierre "Greywacke" du Toit
[email protected]
don't worry about my 0 thankyou's either way, i would say thank you should you help, and i will gladly help others when this work rush is over.
Microsoft JET Database Engine (0x80040E14) Syntax
