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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
