sSql := ' SELECT 0 as ID, E.Dept,Sum(E.Wage) as Wage,Sum(A0) as A0,' + ' Sum(A1) as A1,Sum(A2) as A2,Sum(A3) as A3,Sum(A4) as A4,Sum(A5) as A5,Sum(A6) as A6,Sum(A7) as A7,Sum(A8) as A8,Sum(A9) as A9,Sum(A10) as A10,' + ' Sum(A11) as A11,Sum(A12) as A12,Sum(A13) as A13,Sum(A14) as A14,Sum(A15) as A15,Sum(A16) as A16,Sum(A17) as A17,Sum(A18) as A18,Sum(A19) as A19,Sum(A20) as A20,' + ' Sum(A21) as A21,Sum(A22) as A22,Sum(A23) as A23,Sum(A24) as A24,Sum(A25) as A25,Sum(A26) as A26,Sum(A27) as A27,Sum(A28) as A28,Sum(A29) as A29,Sum(A30) as A30' + ' FROM Employe AS E LEFT JOIN WageTable AS W ON E.ID = W.EmployeID' + ' WHERE E.Admin<>1' + ' GROUP BY E.Dept'; 再有：
sSql := ' SELECT w.ID,w.TreeParent,w.UserCode,w.Name,w.Shortname,' + ' w.Unit,w.Unit2,w.Scale,i.Billdate,Sum(s.Number)As SumNumber,s.Price,Sum(s.Number*s.Price) as Total' + ' FROM Ware w,BillIndex i,BillStock s WHERE i.Type=1 and s.Type=1 and i.ID=s.IndexID and s.WareID=w.ID and ' + ' i.Mode=' + IntToStr(STOCK_ORDER_EDIT) + ' and ' + ' (i.Billdate >= ''' + sStartDate + ''' AND i.Billdate <=''' + sEndDate + ''')' + ' GROUP BY w.ID,w.TreeParent,w.UserCode,w.Name,w.Shortname,w.Unit,w.Unit2,w.Scale,i.BillDate,s.Price';
