Pivot Tables

Hi
I have a table that looks like this:

product_id product_name

1		item1
2		item1
3		item1

Is there a way using SQL to make it look like this:

product_name Alias1 Alias2 Alias3

item1                 1        2          3

thanks

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 14:07:49 CST