UPDATE d, h SET
h.Amount=SUM(d.Amount)
WHERE h.XDate>='2006-01-01'
AND h.id=d.id
GROUP BY d.TX_NO请教上述语句为何出错?错在哪?
h.Amount=SUM(d.Amount)
WHERE h.XDate>='2006-01-01'
AND h.id=d.id
GROUP BY d.TX_NO请教上述语句为何出错?错在哪?
(select SUM(d.Amount) from h,d
WHERE h.XDate>='2006-01-01' AND h.id=d.id
GROUP BY d.TX_NO)
不支持 sub-select