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

Reply via email to