I've got the following data:
ITEM TYPE QTY
A II 10
A IM 20
A IT 30
A OH 40
I want to query this table and produce a single row:
ITEM II IM IT OH
A 10 20 30 40
Can I do this?
Printable View
I've got the following data:
ITEM TYPE QTY
A II 10
A IM 20
A IT 30
A OH 40
I want to query this table and produce a single row:
ITEM II IM IT OH
A 10 20 30 40
Can I do this?
search the forum for "pivot" or "crosstab"