using output of a subselect in LIKE/ILIKE

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: PostgResql SQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: using output of a subselect in LIKE/ILIKE
Date: 2002-04-11 14:04:28
Message-ID: 3CB597EC.6AE67F76@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Ellerbrock 2002-04-11 14:08:38 Re: REPOST: Trouble with SQL conversion
Previous Message Christopher Kings-Lynne 2002-04-11 13:28:32 Re: REPOST: Trouble with SQL conversion