i use oracle as my database and
i have a table like this
ID TAG MIN AVG MAX
---------------------------------------
1101 Brite 12 15 16
1101 Dirt 2 4 7

how to make a view from table above,with the structure like this

ID BriteMin BriteAvg BriteMax DirtMin DirtAvg DirtMax
-------------------------------------------------------------------------
1101 12 15 16 2 4 7

plz reply me a.s.a.p plz....