帮忙看这个语句该怎么写

chenfei20018 发布于 2007-12-14 19:14， 842 次点击

ID   BusNo     BegLc     EndLc    Time
1    1001      NULL      1000     2007-11
2    1001      NULL      NULL     2007-12
如何写一个语句,可以把相同BusNo的2007-11的EndLc UpDate为2007-12的BegLc

2 回复

purana2007-12-14 19:30

update a set a.endlc=b.beglc
from t a
join
(
select * from t where time='2007-12'
) b
on a.busno=b.busno
where a.time='2007-11'

chenfei200182007-12-15 16:40

问题解决了,谢谢斑竹