呵呵,楼上的错了一点点: select a.Pid,a.dataA,dataB=max(b.dateB) from A,B where Pid=Fid and dateB<dataA group by a.Pid,a.dataA或者:select a.Pid,a.dataA,dataB=(select max(b.dateB) from B where Pid=Fid and dateB<dataA) from a
哈哈,斑竹,樓主搞錯了,應是条件:dateB>dateA,但是最靠近dateAselect a.Pid,a.dataA,dataB=min(b.dateB) from A,B where Pid=Fid and dateB>dataA group by a.Pid,a.dataA或者:select a.Pid,a.dataA,dataB=(select min(b.dateB) from B where Pid=Fid and dateB>dataA) from a
select a.Pid,a.dataA,dataB=max(b.dateB) from A,B where Pid=Fid and dateB<dataA group by a.Pid,a.dataA或者:select a.Pid,a.dataA,dataB=(select max(b.dateB) from B where Pid=Fid and dateB<dataA) from a
jameszht(湖泊) 很细心!
http://www.csdn.net/expert/topic/701/701403.xml?temp=.7961542