Joins written using the earlier method may still work, but they may produce unexpected results. For example, if you wrote this:
FROM table1, table2 LEFT JOIN table3 ON (expr)it is parsed like this:
FROM table1, (table2 LEFT JOIN table3 ON (expr))instead of like this
FROM (table1, table2) LEFT JOIN table3 ON (expr)Putting the parentheses around the table names forces the query to run as expected, and it allows you to refer to columns within table1 in the expression.
Simon Jessey | Keystone Websites
Save $97 on yearly plans with promo code [color=#CC0000]SCJESSEY97[/color]