Products

id   |   name
1    |    shirt
2    |    pant


ProductDetails

id     |  product_id  |    size    | inventory
1      |    1         |      M     |     5
3      |    1         |      L     |     10
4      |    1         |      S     |     10
5      |    2         |      S     |     99
6      |    2         |      M     |     99



I want to do query that returns this, is this possible?  

Product Name  | Size S | Size M | Size L          
Shirts        |   10   |   5    |   10   |
Pant          |   99   |   99   |    0   |