Hello,
> mysql> select *from accounting where uid = (select uid > from user wher gid="apswan"); > ERROR 1064: You have an error in your SQL syntax near > 'select uid from user wher gid="apswan")' at line 1 > mysql> Take care, you wrote "wher" instead of "where". And as Leonardo pointed out, the version you're using does probably not support subqueries. You might try to write your query as follows: select accounting.* from accounting left join user on accounting.uid = user.uid where user.gid="apswan"; Jean-Pierre -- Powered by Linux From Scratch - http://schwicky.net/ PGP Key ID: 0xEE6F49B4 - AIM/Jabber: Schwicky - ICQ: 4690141 Nothing is impossible... Everything is relative! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]