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...
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