Received: from web20804.mail.yahoo.com (web20804.mail.yahoo.com [216.136.226.193]) by postgresql.org (Postfix) with SMTP id BCE8A47702E for ; Thu, 11 Apr 2002 10:48:07 -0400 (EDT) Message-ID: <20020411144818.39555.qmail@web20804.mail.yahoo.com> Received: from [68.14.98.218] by web20804.mail.yahoo.com via HTTP; Thu, 11 Apr 2002 07:48:18 PDT Date: Thu, 11 Apr 2002 07:48:18 -0700 (PDT) From: Jeff Eckermann Subject: Re: using output of a subselect in LIKE/ILIKE To: Rajesh Kumar Mallah , PostgResql SQL Mailing List In-Reply-To: <3CB597EC.6AE67F76@trade-india.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200204/137 X-Sequence-Number: 7402 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 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/