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
