| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Keith C. Ivey | Date: | July 5 2002 8:41pm |
| Subject: | Re: Multiple INNER JOINs | ||
| View as plain text | |||
On 5 Jul 2002, at 18:27, Dillon, John wrote: > Can I just check: should it be OK to do multiple INNER JOINs like > this: > > SELECT * FROM (((table1 INNER JOIN table2 ON table1.anyfield = > table2.anyfield) INNER JOIN table3 ON table3.anyfield=table2.anyfield) > INNER JOIN table4 on table4.anyfield=table1.anyfield) WHERE... Yes, but you should leave off those parentheses. > sql,query -- Keith C. Ivey <keith@stripped> Tobacco Documents Online http://tobaccodocuments.org
| Thread | ||
|---|---|---|
| • Multiple INNER JOINs | John Dillon | 5 Jul |
| • Re: Multiple INNER JOINs | Keith C. Ivey | 5 Jul |