All: Help says: "You can use multiple joins in the same SQL statement to query data from as many tables as you like."
What is an effective syntax for INNER JOINing three (or more) tables? I've experimented with joining temp views to keep the database unsullied, and it works (here abstracted a bit): CREATE TEMP VIEW vwenchilada + AS SELECT (t1.columns,t2.columns) + FROM table-1 t1 + INNER JOIN table-2 + ON t1.pkcolumn=t2.pkcolumn + WHERE (clause) CREATE TEMP VIEW vwburrito + AS SELECT (t3.*,t4.columns) + FROM vwenchilada t3 + INNER JOIN table-4 t4 + ON t3.pkcolumn=t4.pkcolumn + WHERE (clause) + ORDER BY (tx.columns) Is there a sleeker way to do this? thanks! bruce chitiea safesectors inc
