0> Is there any benefit in doing:
> SELECT a.f1, a.f2, b.f3 FROM t1 a INNER JOIN t2 b ON a.f1=b.id WHERE a.f1>IMO, the "join" syntax is the preffered syntax.>
> rather than
> SELECT a.f1, a.f2, b.f3 FROM t1 a , t2 b WHERE a.f1> 0 and a.f1 = b.id
1 - it's "newer" (SQL92 as opposed to SQL89)
2 - it's easier to read (especially when joining multiple tables)
3 - it's more clear (you're "joining" to show that you're getting data from
multiple tables in the FROM clause of your statement, makes perfect sense)
4 - you can easily modify the join options (eg: LEFT JOIN) without having
to re-write the query
5 - think of "where" as restrictions on the output rather then a place of
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!