Is there a better construct for the WHERE clause in a LEFT JOIN than
WHERE (x = 17 OR x IS NULL) ? 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