联合查询SQL语句怎么写

1.SELECT 日期,部门,商品编码,商品名称,期初数量,0 as 购入数量,0 as 调入数量,0 as 调出数量,0 as 报废数量
FROM 期初
union all
SELECT 日期,部门,商品编码,商品名称,0 as 期初数量,购入数量,0 as 调入数量,0 as 调出数量,0 as 报废数量
FROM 购入
union all
SELECT 日期,调入部门 as 部门,商品编码,商品名称,0 as 期初数量,0 as 购入数量,调拨数量 as 调入数量,0 as 调出数量,0 as 报废数量
FROM 调拨
union all
SELECT 日期,调出部门 as 部门,商品编码,商品名称,0 as 期初数量,0 as 购入数量,0 as 调入数量,(-[调拨数量]) as 调出数量,0 as 报废数量
FROM 调拨
UNION ALL SELECT 日期,部门,商品编码,商品名称,0 as 期初数量,0 as 购入数量,0 as 调入数量,0 as 调出数量,报废数量
FROM 报废;

2.SELECT 查询1.部门, 查询1.商品编码, 查询1.商品名称, Sum(查询1.期初数量) AS 期初数量之总计, Sum(查询1.购入数量) AS 购入数量之总计, Sum(查询1.调入数量) AS 调入数量之总计, Sum(查询1.调出数量) AS 调出数量之总计, Sum(查询1.报废数量) AS 报废数量之总计, Sum(([期初数量]+[购入数量]+[调入数量]+[调出数量]-[报废数量])) AS 库存
FROM 查询1
GROUP BY 查询1.部门, 查询1.商品编码, 查询1.商品名称
HAVING (((查询1.部门)=[请输入部门，如：赤岗店]));
未尽事项请自行完善或继续交流。