Re: [GENERAL] SELECT query experts, anyone?

[Tino Wildenhain]

Teemu Juntunen wrote:

Hi Experts,

product2; manufacturer3;
product3; manufacturer1;.. manufacturerN-1

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 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?

This should work:



or something along the lines of the above.

Regards
Tino

SELECT product,array(SELECT manufacturer FROM manufacturers WHERE manufacturer_id=products.manufacturer_id) WHERE ...

smime.p7s
Description: S/MIME Cryptographic Signature