RE: Possible problem with outer join in 4.1.2

2004-06-11 Thread SGreen
cc: "'Mysql'" <[EMAIL PROTECTED]> 06/11/2004 04:01 Fax to:

RE: Possible problem with outer join in 4.1.2

2004-06-11 Thread Rick Robinson
--Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 3:05 PM To: [EMAIL PROTECTED] Cc: Mysql Subject: Re: Possible problem with outer join in 4.1.2 Hi Rick, First, the MySQL IsNULL() function does not operate like the ORACLE or MS SQL version. It

Re: Possible problem with outer join in 4.1.2

2004-06-11 Thread SGreen
Hi Rick, First, the MySQL IsNULL() function does not operate like the ORACLE or MS SQL version. It is merely a test and returns either 1 or 0. You will need to use COALESCE() to provide a non-null replacement for a null value. I am not sure what you are trying to accomplish with your EXISTS() cl