Re: using output of a subselect in LIKE/ILIKE

SELECT branch from branches
where outstation like
(SELECT city from users join
personal_account_details
using(userid) where email='ratans(at)cal(dot)vsnl(dot)com') ||
'%'

--- Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
wrote:
> Hi folks,
>
> I need to do something like :
>
> SELECT branch from branches
> where outstation like
> SELECT city from users join
> personal_account_details
> using(userid) where email='ratans(at)cal(dot)vsnl(dot)com'
>
> The above does not work for obvious reasons , but
> can anyone help me
> with the right SQL?
>
>
> regds
> Rajesh Kumar Mallah.
>
>
>
>

__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/