Hi, Razzak: What results are displayed when using the following command?
TALLY RDY_DATE FROM TEMPVIEW RDY_DATE Number of Occurrences ------------------------------------ --------------------- 12/17/2008 1 10/24/2009 4 10/29/2009 1 03/17/2010 1 06/10/2010 32 07/03/2010 1 07/04/2010 12 07/05/2010 18 07/09/2010 5 07/14/2010 1 07/17/2010 10 07/19/2010 1 07/24/2010 3 07/31/2010 1 08/01/2010 1 08/02/2010 9 08/06/2010 2 08/07/2010 1 08/10/2010 4 08/11/2010 7 08/14/2010 2 08/15/2010 1 08/17/2010 2 08/19/2010 2 08/21/2010 4 08/23/2010 1 08/24/2010 4 08/25/2010 26 08/26/2010 28 08/27/2010 8 08/28/2010 25 08/29/2010 14 08/30/2010 33 08/31/2010 23 09/01/2010 134 09/02/2010 70 09/03/2010 51 09/04/2010 121 09/05/2010 73 09/06/2010 23 09/07/2010 277 09/08/2010 170 09/09/2010 108 09/10/2010 31 09/11/2010 28 09/12/2010 18 09/13/2010 20 09/14/2010 138 09/15/2010 51 09/16/2010 67 09/17/2010 92 09/18/2010 30 09/19/2010 7 09/20/2010 43 09/21/2010 107 09/22/2010 12 09/23/2010 61 09/24/2010 149 09/25/2010 94 09/26/2010 24 09/27/2010 92 09/28/2010 64 09/29/2010 47 01/01/9999 253 -0- 57 What is the database SETting for EQNULL? SHOW EQNULL (EQNULL ) OFF Treat null EQual NULL as a match I tried setting it to ON and got the same results. show version R:BASE v8.0 for Windows (32-bit), U.S. Version, Build: 8.0.23.30809 From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: 10/01/2010 11:55 AM Subject: [RBASE-L] - Re: LEFT OUTER JOIN puzzler Sent by: [email protected] At 11:18 AM 10/1/2010, [email protected] wrote: >I'm officially confused. > >Third test: > >SELECT COUNT(STCD_NO) FROM TEMPVIEW WHERE RDY_DATE IS NULL > COUNT (STC > ---------- > 2800 Mike, What results are displayed when using the following command? TALLY RDY_Date FROM TempView What is the database SETting for EQNULL? SHOW EQNULL will reveal the current setting for EQNULL. Hope that provides you with some blue's clues ... Very Best R:egards, Razzak. Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
