Wednesday, August 20, 2008

[GENERAL] SELECT query experts, anyone?

Hi Experts,
 
is threre any way to SELECT values in columns instead of rows? For example select products and their manufacters in the followin way:
 
product1; manufacturer1; manufacturer2;,,, manufacturerN
product2; manufacturer3;
product3; manufacturer1;.. manufacturerN-1
 
With a function you could put the product manufacturers in one string, but I would like to have them in columns. 
 
How about arrays. Is there a way to SELECT values in an array to columns?
 
Best regards and thanks,
Teemu Juntunen

No comments: