求一条查询语句!!!!!!
wg168 2003-11-20 08:25:31 表结构如下
Pro_ID Num_In Num_Out Stor_ID
0011 1 0 001
0002 2 1 001
0023 5 0 001
0011 20 1 002
0002 2 4 002
我想统计为
Pro_ID Stor1_In Stor1_Out Stor2_In Stor2_Out Stor3_In Stor3_Out
0011 1 0 20 1 0 0
0002 2 1 2 4 0 0
0023 5 0 0 0 0 0