Re: left outer join issue? - Mailing list pgsql-general

On Tuesday 18 May 2004 02:26 pm, Dev wrote:
> 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%") )

Use
        LEFT OUTER JOIN table4 AS d ON (a.field1 ILIKE '%' || d.field2 || '%')

-miker