select isnull(ta.YrWk, tb.YrWk) YrWk, tb.Acct, isnull(tb.Usage, 0) Usage from TableA ta full outer join TableB tb on ta.YrWk = tb.YrWk;What do you want to do with account column? As is, it will show up in the results as NULL (for not reported weeks) and if you need to display the misssing acount numbers instead of diplaying null then you need to include an Acct column from the Account parent table in the mix, something like this (assuming that you do have a parent account table which has Acct column with unique Acct value in every record). You can then afford go with left join :)
select ta.YrWk, ac.Acct, isnull(tb.Usage, 0) Usage from TableA ta cross join Account ac left join TableB tb on ta.YrWk = tb.YrWk and ac.Acct = tb.Acct order by 2, 1;
No one has followed this question yet.