Select 品名,Sum(出数量) As 出数量,Sum(进数量) As 进数量,Sum(进数量)-Sum(出数量) As 库存 into 库存表(Select 品名,Sum(数量) As 出数量,0 as 进数量 From 出货表 Group By 品名Union AllSelect 品名,0 as 出数量,Sum(数量) As 进数量 From 进货表 Group By 品名) a Group By 品名 上面是sqlserver的语法：careate table 库存表 asSelect 品名,Sum(出数量) As 出数量,Sum(进数量) As 进数量,Sum(进数量)-Sum(出数量) As 库存(Select 品名,Sum(数量) As 出数量,0 as 进数量 From 出货表 Group By 品名Union AllSelect 品名,0 as 出数量,Sum(数量) As 进数量 From 进货表 Group By 品名) a Group By 品名 上面是oracle的语法