您所在位置：主题：请问这条语句为什么在orcale9i中说没有右括号
hefangshi
[专家分：0] 发布于 2006-01-25 08:59:00
SELECT a.hopper,b.material_id,b.pile_no,b.dosage,c.material_id,c.pile_no,c.dosage,d.material_id,d.pile_no,d.dosage
FROM (((SELECT hopper FROM MIX_CONSUME ORDER BY hopper) AS a LEFT OUTER JOIN (SELECT hopper,material_id,pile_no,dosage FROM MIX_CONSUME WHERE shift=2) AS b ON a.hopper=b.hopper) LEFT OUTER JOIN (SELECT hopper,material_id,pile_no,dosage from MIX_CONSUME where shift=3) AS c ON a.hopper=c.hopper) LEFT OUTER JOIN (SELECT hopper,material_id,pile_no,dosage FROM MIX_CONSUME WHERE shift=1) AS d ON a.hopper=d.hopper
FROM (((SELECT hopper FROM MIX_CONSUME ORDER BY hopper) AS a LEFT OUTER JOIN (SELECT hopper,material_id,pile_no,dosage FROM MIX_CONSUME WHERE shift=2) AS b ON a.hopper=b.hopper) LEFT OUTER JOIN (SELECT hopper,material_id,pile_no,dosage from MIX_CONSUME where shift=3) AS c ON a.hopper=c.hopper) LEFT OUTER JOIN (SELECT hopper,material_id,pile_no,dosage FROM MIX_CONSUME WHERE shift=1) AS d ON a.hopper=d.hopper
