MySQL Query : select mh.yyname from v9_member_hospital as mh left join v9_member as m on mh.userid=m.userid where mh.userid =(select md.parent_id from v9_member_doctor as md left join v9_member as m on md.userid=m.userid where md.userid=) MySQL Error : 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 ')' at line 1 MySQL Errno : 1064 Message : 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 ')' at line 1 Need Help?