I'm using the following script:
select b.BEG_BAL, b.ACCt , b.FISCAL_YR
from BegBalance2015 b left outer join GLTrxPrdYear g on b.ACCT = g.GL_ACCOUNT and g.year=b.FISCAL_YR
group by b.beg_bal, b.acct, b.FISCAL_YR
order by b.ACCT
If I try to add a column from GLTrxPrdYear row 15 disappears because there are no trx's for that Acct for 2015, but I still need to show the account and its beginning balance. I though the left outer join would do the trick but its not.
Is there another way I can get this accomplished?