Maybe: WHERE coalesce(x, 17) = 17
""Jerry Schwartz"" <jschwa...@the-infoshop.com> escreveu na mensagem news:023301cac069$366afa00$a340ee...@com... > 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 > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
