Hi,
How could
select
row1 a1,b1.qty, b2.qty, b3.qty
row2 a2,b1.qty, b2.qty, b3.qty
row3 a3,b1.qty, b2.qty, b3.qty
...
from a table :
row1 a1,b1,qty
row2 a1,b2,qty
row3 a1,b3,qty
row4 a2,b1,qty
row5 a2,b2,qty
row6 a2,b3,qty
row7 a3,b1,qty
....
Best regard!
Shuming　Wang
