Would something like this work for you

Select Concat ( firstName,LastName) OR Select firstName|| ' ' || LastName

Into A.Name

FRom Table A A Inner JOIN TableB B

where A.ID = B.ID