Firebird, rows as columns?

[dohamsg]

I use firebird 2.0

I have two tables:

1- Product
with some columns :
ProductID, ProductCode...

2- PriceList
with some columns :
ProductID, Price...

* A Product may have many prices

The user wants to see the Product list with corresponding prices on the same row.

Any idea how to achieve this. Thanks.

[chazzy]

isn't this just a basic join?


select productid,productcode,price from product p, pricelist pl where p.productid=pl.productid