1. Select a.Tptal+b.Total as total
from Student as a inner join TUI as b
on a.ID=b.STUDENTID
是否是这个意思?
2. FormatCurr('0.00',金额), 或CurrToStr
from Student as a inner join TUI as b
on a.ID=b.STUDENTID
是否是这个意思?
2. FormatCurr('0.00',金额), 或CurrToStr
调试欢乐多
SET TOTAL = A.TOTAL + B.TOTAL
FROM STUDENT A
INNER JOIN (
SELECT STUDENTID, SUM(TOTAL) AS TOTAL
FROM TUI
GROUP BY STUDENTID
) B ON B.STUDENTID = A.ID
from Student as a inner join
TUI as b on a.ID=StudentID
from Student a,TUI b
where a.ID=b.StudentID