| From: | Dev <dev(at)umpa-us(dot)com> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: left outer join issue? |
| Date: | 2004-05-18 18:26:18 |
| Message-ID: | 6.1.0.6.2.20040518142442.044b4ec0@pop.umpa-us.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 02:28 PM 5/18/2004, Bruno Wolff III wrote:
>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.
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
----------
UMPA
Brian C. Doyle
Director, Internet Services
United Merchant Processing Association
<http://www.umpa-us.com>http://www.umpa-us.com
1-800-555-9665 ext 212
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2004-05-18 18:28:57 | Re: left outer join issue? |
| Previous Message | Dev | 2004-05-18 18:10:04 | left outer join issue? |