SELECT bs.nname, ; NVL(a1.street, SPACE(LEN(a1.street))) AS adr1street, ; NVL(a2.street, SPACE(LEN(a2.street))) AS adr2street, ; NVL(a3.street, SPACE(LEN(a3.street))) AS adr3street, ; NVL(a4.street, SPACE(LEN(a4.street))) AS adr4street ; FROM base bs ; LEFT JOIN address a1 ON a1.keyfield = bs.keyfield ; AND a1.addrtype = "A1" ; LEFT JOIN address a2 ON a2.keyfield = bs.keyfield ; AND a2.addrtype = "A2" ; LEFT JOIN address a3 ON a3.keyfield = bs.keyfield ; AND a3.addrtype = "A3" ; LEFT JOIN address a4 ON a4.keyfield = bs.keyfield ; AND a4.addrtype = "A4" ; ...>Hello Sergey,