Larry: Between this and the workaround, I'm in great shape.
Thanks much. bruce > -------- Original Message -------- > Subject: [RBASE-L] - Re: Inner Join: Joining 3 or more tables? > From: Lawrence Lustig <[email protected]> > Date: Tue, November 16, 2010 11:21 am > To: [email protected] (RBASE-L Mailing List) > > > You can perform multiple INNER JOINs in a single statement using the older > SQL-89 syntax: > > SELECT * FROM table1, table2, table3 + > WHERE table1.colX = table2.colY AND table2.colA = table3.colB > > Unfortunately, this works only for implicit INNER JOINs in the older syntax. > For SQL-92 syntax (which is the only way to do OUTER JOINs) you are limited > to > 2 tables per SELECT statement. The work-around there is to use nested views > as > described in your message. > -- > Larry
