I need help with a sql query. I have the following and need to make it header a header field with that value.
ID WAREHOUSE QTY
AB1 SOUTHBLD 10
AB1 WESTBLD 2
AB1 NORTHBLD 4
Need it as followed:
ID SOUTHBLD WESTBLD NORTHBLD TOTAL Qty
AB1 10 2 4 16
How could I take the following sql query to get that?
Select Id, warehouse, qty from warehouse where id = 'AB1'