t-sql方式left出表1.sql

来自「地方政府非税收入管理程序。powerbulider8开发。」· SQL 代码 · 共 24 行

SELECT t_print1.hang,   
         t_print1.dwdm,   
         t_dwdm.dwname,   
         t_print1.sfdm,   
         t_sfdm.sfxm,   
         sum( t_mx.money),   
         sum( t_mx.money)  
    FROM t_print1,   
         t_dwdm,   
         t_sfdm,
	t_mx 

   WHERE t_print1.dwdm *= t_mx.dwdm AND t_print1.sfdm *= t_mx.sfdm and
		( t_print1.dwdm = t_dwdm.dwdm ) and  
         ( t_print1.sfdm = t_sfdm.sfdm )
 and  
         ( ( t_mx.IN_Time >= '20060501' ) AND  
        ( t_mx.IN_Time <= '20060526' ) )  
GROUP BY t_print1.hang,   
         t_print1.dwdm,   
         t_print1.sfdm,   
         t_dwdm.dwname,   
         t_sfdm.sfxm  
ORDER BY t_print1.hang ASC