Re: left outer join issue?

At 02:28 PM 5/18/2004, Bruno Wolff III wrote:

On Tue, May 18, 2004 at 14:10:04 -0400,
  Dev <dev@umpa-us.com> wrote:
>
> 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?

Use the ON clause syntax.

Here is what it actually looks like
 LEFT OUTER JOIN table4 AS d ON (a.field1 ilike "%d.field2%") )

a is setup for table1 and it is reference in a few other left outer joins. 

Those "other" outer joins work fine with out this new part

---

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