At 11:46 AM -0500 1/30/08, Jerry Schwartz wrote:
The documentation says (I think) that you should not use an ON join
condition when you can use a WHERE, but I'm pretty sure someone from
MySQL.com posted a message suggesting the opposite.
The manual says this:
"The ON conditional is any conditional expression of the form that
can be used in a WHERE clause. Generally, you should use the ON
clause for conditions that specify how to join tables, and the WHERE
clause to restrict which rows you want in the result set."
See: http://dev.mysql.com/doc/refman/5.0/en/join.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
