Re: left outer join issue?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dev <dev(at)umpa-us(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: left outer join issue?
Date: 2004-05-18 18:28:57
Message-ID: 20040518182857.GA2282@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, May 18, 2004 at 14:10:04 -0400,
Dev <dev(at)umpa-us(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2004-05-18 18:40:40 Re: Access to the DB
Previous Message Dev 2004-05-18 18:26:18 Re: left outer join issue?