Viewing 3 posts - 136 through 139 (of 139 total)
Quick note: you swapped the sides of the join between your first chunk of code and your second. The CSCSHBAL table should be the one the join direction...
R David Francis
May 6, 2003 at 10:33 am
#456301
What happens if you switch it to a LEFT OUTER JOIN? I always get a bit dyslexic with these things....
May 6, 2003 at 10:30 am
#456300
TO be clear - if you change:
...
FROM CSCRDTTL b RIGHT OUTER JOIN CSCSHBAL a
ON a.DBR_DATE=b.DBR_DATE
WHERE ...
to:
ON (a.DBR_DATE=b.DBR_DATE and a.STORE_ID = b.STORE_ID)
you don't...
May 6, 2003 at 8:26 am
#456285