其中t_XiangmuBHs 相当于table1，t_HeTong_new相当于table2
select distinct a.xiangmubh,a.xmnianfen,hetongxmmc,Touzije,HeTongMC,HeTongNF,HeTongNR,HeTongBH,HeTongJE
from ( select xiangmubh,xmnianfen,hetongxmmc,Touzije from t_XiangmuBHs ) as a
left join (select xiangmubh,HeTongMC,HeTongNF,HeTongNR,HeTongBH,HeTongJE from t_HeTong_new ) as b
on a.xiangmubh='1500310232' and a.xiangmubh=b.xiangmubh

xiangmubh xmnianfen hetongxmmc Touzije HeTongMC HeTongNF HeTongNR HeTongBH HeTongJE
-------------------- --------- -------------------------------------------------- ------------- -------------------------------------------------------------------------------- -------- -------------------------------------------------------------------------------- -------------------- ------------
1500240510 2003 江门1860节点配套 1547.00 NULL NULL NULL NULL NULL
1500280401 2003 江门移动综合楼 11505.95 NULL NULL NULL NULL NULL
1500280402 2003 新会移动综合楼 2780.00 NULL NULL NULL NULL NULL
1500310232 2003 8期交换系统配套 245.00 NULL NULL NULL NULL NULL
1500310232 2003 8期交换系统配套 245.00 NULL 2003 NULL NULL NULL
1500310232 2003 8期交换系统配套 245.00 NULL 2003 NULL NULL 2162904.10
1500310232 2003 8期交换系统配套 245.00 .00
1500310232 2003 8期交换系统配套 245.00 AM8扩容工程配套 2004 一次性付款 NULL 54000.00