>My table is:
>type price
>car 1000
>bike 100

>I want the result:
>car bike
>1000 100


You seem to want to turn rows into columns. That's often called a "pivot table". There's a step-by-step for pivot tables at http://www.artfulsoftware.com/queries.php#24. There're other pivot table examples on the same page.

PB