数据合并有关问题！最好用sql查出来

2012-03-02

数据合并问题！最好用sql查出来！怎样将数据合并！原数据如下所示：BJIDJD1KSSJJSSJJD2KSSJJSSJ--------------

数据合并问题！最好用sql查出来！
怎样将数据合并！原数据如下所示：

BJIDJD1 KSSJJSSJ JD2 KSSJ JSSJ
-------------------------------------
11 2007-04-122007-05-02
1001-11 2007-04-122007-04-18
1001-1 2 2007-04-18 2007-05-02
1001-21 2007-04-122007-04-20
1001-2 2 2007-04-20 2007-05-02

合并好的数据是这样的！
BJIDJD1 KSSJJSSJ JD2 KSSJ JSSJ
-------------------------------------
11 2007-04-122007-05-02
1001-1 1 2007-04-122007-04-18 2 2007-04-18 2007-05-02
1001-21 2007-04-122007-04-20 2 2007-04-20 2007-05-02

[解决办法]
接分