Update Final Table With Values Into Comma Separator?

I would like to update the final table with values into a comma separator as follows with examples:

I think I have the IDs set correctly for this example:

You can see from the final table that the code column can be a combination of more than one rows from the map tables...

create table #tblTax(TaxStatusID int, FullName varchar(20)
insert into #tblTax values(1, 'Taxable')
insert into #tblTax values(2, 'exempt')

create table #tblTypes(TypeID int, description varchar(100)
insert into #tblTypes values(1, 'cor')
insert into #tblTypes values(2, 'tyr')

[code]....

Looking at the above example, I would like to have the #tblMain as follows

#tblMain
ShoetNameLongNameClientNameTaxIDTypeID
======================================================================
A, B'dand, Barlow''johnson'133
G'mond''anderson'26
I'somelongcode''jacksons'21
A, B'dand, Barlow''smith'112