sql on no primary key table

[aloysiusf]

hey guys.
I have this table as follows

PRODUCT
prod_serial prod_name prod_price
1 box 100
2 pencil 200
3 pen 50

ATTRIBUTE
atti_serial attr_value
1 a1
1 a3
2 b1
2 b2
2 b3
3 c1

How do i get the output as below with only one SQL statement

prod_serial temp1 temp2 prod_name prod_price
1 a1 a2 box 100

or

prod_serial temp1 temp2 temp3 prod_name prod_price
2 b1 b2 b3 pencil 200

Thanks

[nemonoman]

You can't create the desired return with a single SQL statement.

You can with a single SQL statement create an array of returned rows that can be manipulated in PHP to produce that sort of result, however.