List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 18 2003 3:39pm
Subject:Re: subselect
View as plain text  
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.

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
Thread
subselectgeeta varu18 Mar
  • Re: subselectPaul DuBois18 Mar