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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
