SELECT branch from branches
where outstation like
(SELECT city from users join
personal_account_details
using(userid) where email='ratans@cal.vsnl.com') ||
'%'
--- Rajesh Kumar Mallah <mallah@trade-india.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@cal.vsnl.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/