Teemu Juntunen wrote:
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;,,, manufacturerNproduct2; manufacturer3; product3; manufacturer1;.. manufacturerN-1With 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?
This should work:SELECT product,array(SELECT manufacturer FROM manufacturers WHERE manufacturer_id=products.manufacturer_id) WHERE ...
or something along the lines of the above. Regards Tino
smime.p7s
Description: S/MIME Cryptographic Signature