Exists
Posted: Mon Jan 19, 2004 8:42 am
Mysql
What am i doing wrong:
the subquery works fine alone.
The error i get is :
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXISTS (
SELECT DISTINCT *
FROM games g, players_games pg
W
What am i doing wrong:
Code: Select all
select id from games where exists
(SELECT * FROM games g, players_games pg where g.id=pg.gid)The error i get is :
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXISTS (
SELECT DISTINCT *
FROM games g, players_games pg
W