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 <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php