|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
ON vs. WHERE
From: Jerry Schwartz (jschwartz
the-infoshop.com)
Date: Wed Jan 30 2008 - 10:46:10 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
Aside from LEFT JOINs, which require an ON, does anyone have any opinions or
experience?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
<http://www.the-infoshop.com> www.the-infoshop.com
<http://www.giiexpress.com> www.giiexpress.com
www.etudes-marche.com
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]