已有表a
bh,rq, sj
1, 2008-08-08,08:00
1, 2008-08-08,17:30
1, 2008-08-08,18:30
1, 2008-08-09,09:00
1, 2008-08-09,17:00
1, 2008-08-09,19:00
2, 2008-08-08,08:00
2, 2008-08-08,12:00
.
.
.已有表b
bh,rq, sj1, sj2, sj3, sj4, sj5, sj6, sj7, sj8, sj9
1, 2008-08-08,
1, 2008-08-09,
2, 2008-08-08,
3, 2008-08-08, 结果:表b
bh,rq, sj1, sj2, sj3, sj4, sj5, sj6, sj7, sj8, sj9
1, 2008-08-08, 08:00, 17:30, 18:30
1, 2008-08-09, 09:00, 17:00, 19:00
2, 2008-08-08, 08:00, 12:00
3, 2008-08-08,求SQL语句,将表a中对应bh及对应rq的sj注入到表b的sj1到sj(N)的列中。
bh,rq, sj
1, 2008-08-08,08:00
1, 2008-08-08,17:30
1, 2008-08-08,18:30
1, 2008-08-09,09:00
1, 2008-08-09,17:00
1, 2008-08-09,19:00
2, 2008-08-08,08:00
2, 2008-08-08,12:00
.
.
.已有表b
bh,rq, sj1, sj2, sj3, sj4, sj5, sj6, sj7, sj8, sj9
1, 2008-08-08,
1, 2008-08-09,
2, 2008-08-08,
3, 2008-08-08, 结果:表b
bh,rq, sj1, sj2, sj3, sj4, sj5, sj6, sj7, sj8, sj9
1, 2008-08-08, 08:00, 17:30, 18:30
1, 2008-08-09, 09:00, 17:00, 19:00
2, 2008-08-08, 08:00, 12:00
3, 2008-08-08,求SQL语句,将表a中对应bh及对应rq的sj注入到表b的sj1到sj(N)的列中。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货