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
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;,,, manufacturerN
product2; manufacturer3;
product3; manufacturer1;..
If you put this in the application, you could do something such as:
my @manufacturers = fetch(select manufacturer_no, name from
manufacturers);
my @select_fields = ('product_no');
foreach my $manufacturer (@manufacturers) {
my $manuf_no = $manufacturer-{manufacturer_no};
my $name =