SELECT MAX(concat(u.nazwa,", ",u.KodPocztowy," ",u.MIasto,", ",u.Ulica," ",u.NrDomu)) as value  FROM IReg I LEFT JOIN US u ON u.GUID = I.valuea WHERE I.idpath = 'INT\\SYSTEM\\MOTLAWA\\DaneFirmy' and I.idkey='Urzad_skarbowy'