I don't think you can do this denormalization with SELECT - SQL only.

You might create a UDF that fetches all telephones for one person. Everything else can be done in the SELECT - SQL command.

>Hi guys,
>
>First of all, I will introduce you my tables:
>

>Table_A                       Table_B
>   ID_A (I) 1--------+        ID_B (I)
>   Name (C)          +------N ID_A (I)
>                              Phone (C)
>

>
>My point is create a cursor like that:
>

>ID_A   Name                   Phone
>0001   Rodolfo Duarte         1234-5678 1234-1234 1234-3333
>0002   Denise Andrade         2222-3333 2222-4444
>

>
>Notice that I have 2 records in my Table_A and 5 records in my Table_B.
>So, is it possible to create my Cursor using just one Select-SQL or I have to process it manually?
>
>TIA