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 |
