数据合并问题!最好用sql查出来!
怎样将数据合并!原数据如下所示:
BJID JD1 KSSJ JSSJ JD2 KSSJ JSSJ
-------------------------------------
1 1 2007-04-12 2007-05-02
1001-1 1 2007-04-12 2007-04-18
1001-1 2 2007-04-18 2007-05-02
1001-2 1 2007-04-12 2007-04-20
1001-2 2 2007-04-20 2007-05-02
合并好的数据是这样的!
BJID JD1 KSSJ JSSJ JD2 KSSJ JSSJ
-------------------------------------
1 1 2007-04-12 2007-05-02
1001-1 1 2007-04-12 2007-04-18 2 2007-04-18 2007-05-02
1001-2 1 2007-04-12 2007-04-20 2 2007-04-20 2007-05-02
------解决方案--------------------接分