does subselect work in mySQL 3.23 ...i'm trying to exceute the following query ...
No subselects until 4.1. Perhaps you can rewrite your query as a join.
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
Select can_ID from TABLE1 where (designation like '%sales%' or designation like '%marketing%')
AND can_ID in
(Select can_ID from TABLE1 where (designation like '%telecom%' or designation like '%software%'))
if no! any solutions please... its urgent>>>>>>>>>>>>>>>
-- Paul DuBois http://www.kitebird.com/ sql, query
--------------------------------------------------------------------- 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
