HI
Does mysql support function EXIST
I got the following error
mysql> select * from arcdata d
-> WHERE year='2003' AND semester='1'
-> AND EXIST (SELECT * FROM arcdata_unitCodes u
-> WHERE u.idnum = d.idnum AND u.semester=d.semester AND u.year=d.year
-> AND unitcode LIKE '433%')
-> limit 1
-> ;
ERROR 1064: You have an error in your SQL syntax near '(SELECT * FROM
arcdata_unitCodes u
WHERE u.idnum = d.idnum A' at line 3
Try to select the student who are atleast doing one computer sciencs
subject (433123, 433252...)
Thanks
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php