Received: from trade-india.com (unknown [130.94.20.28]) by postgresql.org (Postfix) with SMTP id A187F476952 for ; Thu, 11 Apr 2002 10:01:00 -0400 (EDT) Received: (qmail 15595 invoked from network); 11 Apr 2002 14:13:12 -0000 Received: from ptil-235-129-del.primus-india.net (HELO trade-india.com) (203.196.129.235) by 130.94.22.209 with SMTP; 11 Apr 2002 14:13:12 -0000 Message-ID: <3CB597EC.6AE67F76@trade-india.com> Date: Thu, 11 Apr 2002 19:34:28 +0530 From: Rajesh Kumar Mallah X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 To: PostgResql SQL Mailing List Subject: using output of a subselect in LIKE/ILIKE Content-Type: multipart/alternative; boundary="------------A7FAC727E4D9BD82BBB7D9E0" X-Archive-Number: 200204/134 X-Sequence-Number: 7399 --------------A7FAC727E4D9BD82BBB7D9E0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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. --------------A7FAC727E4D9BD82BBB7D9E0 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit 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.
 
 
  --------------A7FAC727E4D9BD82BBB7D9E0--