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
