Something like

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 address1 a1 ON a1.keyfield = bs.keyfield ;
   LEFT JOIN address2 a2 ON a2.keyfield = bs.keyfield ;
   LEFT JOIN address3 a3 ON a3.keyfield = bs.keyfield ;
   LEFT JOIN address4 a4 ON a4.keyfield = bs.keyfield ;
...

>Hello all,
>
>saying a have a base entitity which holds 4 foreign keys to an address table,
>how would a best denormalize this back into a cursor like:
>
>base.nname, address1.street As adr1street, addresse2.street As adr2street, addresse3.street As adr3street, address4.street As adr4street
>
>
>Christian