How to select multiple fields from a joined table

[kimmyshop]

I have two tables - products and productpropertyvalue

I need to select multiple fields from the productpropertyvalue as it corresponds to the product id. The script I am using is

select a.id, a.productname, a.siteprice,
b.propertyvalue

from product a, productpropertyvalue b

where a.id = b.productid and propertyid=590

This allows me to extract only 1 propertyid. I need to make it add 3 other columns for propertyid=589, 617, 615

Any help solving this problem would be appreciated - thanx!

Ron

[Sulley's Boo]

select a.id, a.productname, a.siteprice, b.propertyvalue
from product a, productpropertyvalue b
where a.id = b.productid
and propertyid in (589, 617, 615)

?

[Jx_Man]

sulley's already answered