最近新学习了多表联合，却不能使用，很是遗憾。
帮忙看看那里出现了错误，谢谢。
SELECT distinc workshop,no,user,date,t,pn,status,gjqty,t2.zytime,t3.qty,t4.ll FROM rwd t1 LEFT JOIN ;
(sele DISTINCT rwd,SUM(zytime) zytime  FROM gshb WHERE zytime >0 GROUP BY ) t2 ON t1.no =t2.rwd LEFT JOIN ;
(sele rwd,SUM(qty)qty FROM fgrk t1 LEFT JOIN location t2 ON t1.ck =t2.ck  WHERE t2.hs ='是' GROUP BY 1) t3 ON t1.no =t3.rwd left join;
(sele t1.rwd,SUM(t1.qty*t2.price) ll from scll t1 left join stdcost t2 on t1.pn =t2.pn GROUP BY 1 ) t4 on t1.no =t4.rwd

粗心大意，找到答案了
SELECT distinc workshop,no,user,date,t,pn,status,gjqty,t2.zytime,t3.qty,t4.ll FROM rwd t1 LEFT JOIN ;
(sele DISTINCT rwd,SUM(zytime) zytime  FROM gshb WHERE zytime >0 GROUP BY 1) t2 ON t1.no =t2.rwd LEFT JOIN ;
(sele rwd,SUM(qty)qty FROM fgrk t1 LEFT JOIN location t2 ON t1.ck =t2.ck  WHERE t2.hs ='是' GROUP BY 1) t3 ON t1.no =t3.rwd left join;
(sele t1.rwd,SUM(t1.qty*t2.price) ll from scll t1 left join stdcost t2 on t1.pn =t2.pn GROUP BY 1 ) t4 on t1.no =t4.rwd

楼主，这是多表联接，不是联合。

那是。