SELECT id_a, Name, CAST(PhoneList(id_a) AS char(128)) Phone ; FROM tableAIn the PhoneList you would build a list of phones for the passed ID.
>Table_A Table_B > ID_A (I) 1--------+ ID_B (I) > Name (C) +------N ID_A (I) > Phone (C) >>
>ID_A Name Phone
>0001 Rodolfo Duarte 1234-5678 1234-1234 1234-3333
>0002 Denise Andrade 2222-3333 2222-4444
>
>