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.