龙之吻: join一次不可以嘛? [阅读: 325] 2006-09-04 08:14:26 select A.TheDate, A.Value Today, C.Value Yesterday from (select * from T1) A left join (select dateadd(Day, 1, TheDate) as TheDate,Value from T1) C on A.TheDate=C.TheDate 机器人,这首歌学会了没有? 我们的目标是->没有蛀牙!