Having a little problem with a left outer join. I would expect 351 records (from table J) from the query below, but I’m only getting 125 (which is the number of records from table E).
What’s wrong with this join??? It seems so straight forward ugh.
I’m aware of the (+) and that works fine. But I’m trying to figure out why this code doesn’t work…
Thanks in advance!
max(e.ACTION_DT) as TAX_RATE_APPROVED
DLSGATEWAY.JURISDICTION j left outer join
on j.jurisdictioncode = e.jur_code
e.FISCAL_YEAR IN (2014)
AND j.JURISDICTIONCODE <= 351
and e.process_id > 100