🚀 go-pugleaf

I think you can use subquery to obtain matrix result

But you have to create sql dynamically, and write for every column subquery.

SELECT A.col_1,
  (select col_2 from table2 where col_1 = A.col_1 and .. ) AS "0",
  (select col_2 from table2 where col_1 = A.col_1 and .. ) AS "1",
  (select col_2 from table2 where col_1 = A.col_1 and .. ) AS "2",
  (select col_2 from table2 where col_1 = A.col_1 and .. ) AS "3"
FROM TABLE1 A

"adalberto baldini" <finman@swissonline.ch>, haber iletisinde �unlar� 
yazd�:46418103$1@newsgroups.borland.com...
>I have a procedure that joins two tables and  returns a pairs of columns 
>like :
>
> col_1   col_2
> ------  ------
>  0        0
>  0        1
>  0        2
>  1        1
>  2        0
>  2        1
> .....
>
> I would split col2 into n. columns to represent a matrix result :
>
> a\b    0   1  2  3 ...
> 0      x   x  x
> 1          x
> 2      x   x
> ...
>
> I don't know in advance num^ber of columns I could get.
>
> could anyone suggest if exists any function that could do this or if I 
> need to work with a visual component in Delphi ?
>
> Thans
> Adalberto BAldini