FROM d_leader_change a left join d_new_expense b
on a.Cfgsm = b.cfgsm and a.Cdxsm = b.cdxsm and a.Clrsj = b.clrsj
left join d_new_operation c
on a.Cfgsm = c.cfgsm and a.Cdxsm = c.cdxsm and a.Clrsj = c.clrsj
left join d_new_sales d
on a.Cfgsm = d.cfgsm and a.Cdxsm = d.cdxsm and a.Clrsj = d.clrsj
left join d_oper_rival e
on a.Cfgsm = e.cfgsm and a.Cdxsm = e.cdxsm and a.Clrsj = e.clrsj
left join d_VPMN f
on a.Cfgsm = f.cfgsm and a.Cdxsm = f.cdxsm and a.Clrsj = f.clrsj
...........
----------------------------------
????
on a.Cfgsm = b.cfgsm and a.Cdxsm = b.cdxsm and a.Clrsj = b.clrsj
left join d_new_operation c
on a.Cfgsm = c.cfgsm and a.Cdxsm = c.cdxsm and a.Clrsj = c.clrsj
left join d_new_sales d
on a.Cfgsm = d.cfgsm and a.Cdxsm = d.cdxsm and a.Clrsj = d.clrsj
left join d_oper_rival e
on a.Cfgsm = e.cfgsm and a.Cdxsm = e.cdxsm and a.Clrsj = e.clrsj
left join d_VPMN f
on a.Cfgsm = f.cfgsm and a.Cdxsm = f.cdxsm and a.Clrsj = f.clrsj
...........
----------------------------------
????
例如在2003-12-09,a表只有一条记录是 1、aa aa1 aa2 aa3...2003-12-09
b表有两条记录是 1、bb bbl bb3 bb4...2003-12-09
2、cc cc2 cc3 cc4...2003-12-09
他们合成后效果如下
1、 aa aa1 aa2 aa3 bb bbl bb3 bb4...2003-12-09
2、 cc cc2 cc3 cc4...2003-12-09