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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
