0

Hello I have a table

item1

|   Item    |   Qnty    |   ProdSched   |
|    a      |    1      |       1       |
|    b      |    2      |       1       |
|    c      |    3      |       1       |
|    a      |    4      |       2       |
|    b      |    5      |       2       |
|    c      |    6      |       2       |

is There a way i can output it like this using sql SELECT?

    |   Item    |   ProdSched(1)(Qnty)  |   ProdSched(2)(Qnty)  |
    |    a      |           1           |       4               |
    |    b      |           2           |       5               |
    |    c      |           3           |       6               |

Thank you

1
Contributor
1
Reply
2
Views
5 Years
Discussion Span
Last Post by semicolon
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.