主题：请教 出错 代码如下

selec 产品编码,产品名称,sum(数量) as 入库,0 as 出库 from {原料入库单明细} group by 产品编码,产品名称 union all selec 产品编码,产品名称,0,sum(仓库实发）from {制令单明细} group by 产品编码,产品名称

'）' 附近有语法错误。

selec 产品编码,产品名称,sum(入库)  from (selec 产品编码,产品名称,sum(数量) as 入库,0 as 出库,0 as 剩余  from {原料入库单明细} group by 产品编码,产品名称 union all selec 产品编码,产品名称,0,sum(仓库实发),0 from {制令单明细} group by 产品编码,产品名称)  group by 产品编码,产品名称

关键字 'group' 附近有语法错误。

selec  * from (selec * from {进货单}) 老是出错  ')' 附近有语法错误。