請教sql server分組問題
請問以下代碼在Sql server中為何執行不了,該如何解決,(多字段分組).
SELECT b.subjobno, b.partno, b.item ,b.flowno,b.flowdesc,a.name,a.unit
FROM jobflow b left join icmt a on b.item=a.partno
GROUP BY b.subjobno,b.partno,b.item,b.flowno
[此贴子已经被作者于2006-10-17 16:16:52编辑过]
