Home > mailing lists

left outer join issue? - Mailing list pgsql-general

From	Dev
Subject	left outer join issue?
Date	May 18, 2004 18:10:37
Msg-id	6.1.0.6.2.20040518140844.0259eec0@pop3.umpa-us.com Whole thread Raw
Responses	Re: left outer join issue? (Bruno Wolff III <bruno@wolff.to>)
List	pgsql-general

Hello all,

I need to do a left out join where a.field1 ilike %b.field2%

But I can not figure out the exact syntax to using the ilike in the join?

		Brian C. Doyle
		Director, Internet Services
		United Merchant Processing Association
		http://www.umpa-us.com
		1-800-555-9665 ext 212

From: Richard Huxton
Date: 18 May 2004, 17:58:30
Subject: Re: Help! Error Compiling

From: Bruno Wolff III
Date: 18 May 2004, 18:24:18
Subject: Re: left outer join issue?