Re: Pivot Tables

Create a view with different aliases to
select a subset of values from the table,

e.g.

select a.product_name, b.product_id alais1, c.product_id alias2, d.product_id alias3 from product_table a,
select * from product_table where
product_id =1 b,
select * from product_table where
product_id =2 c,
select * from product_table where
product_id =3 d

where
a.product_id = b.product_id
and
a.product_id = c.product_id
and
a.product_id = d.product_id ;

Probably my example is very crude.
However, it's probably close to
what you are looking for.

Regards
Willy Received on Wed Jan 31 2001 - 22:42:40 CST