At 21:34 -0800 3/17/03, geeta varu wrote:
>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.
>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...
|• subselect||geeta varu||18 Mar|
| • Re: subselect||Paul DuBois||18 Mar|