string sql =" select vm.[units],sum(ts.[Dealmoney]),sum(vm.[onbaoxiao]),sum(vm.[nianbaoxiao]) from VehicMessage vm LEFT JOIN TecSystem ts on vm.card=ts.card group by vm.[card],vm.[units]";
OleDbCommand com = new OleDbCommand(sql); OleDbDataReader reader = com.ExecuteReader();-------±¨´í£¬{"ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ¡£"}
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺 £¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£® µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......