求一简单SQL语句!

SQL code:

/*
表A
vbeln erdat prdha
0090056842 2009-12-02 00:00:00.000 D0EXBX133X
0090058691 2009-12-18 00:00:00.000 D0EXBX133X


表B
erdat1 prdha price rate
2009-12-01 00:00:00.000 D0EXBX133X 90.52 0.020
2009-12-03 00:00:00.000 D0EXBX133X 92.86 0.050
2009-12-10 00:00:00.000 D0EXBX133X 93.88 0.030
2009-12-14 00:00:00.000 D0EXBX133X 95.20 0.080
2009-12-18 00:00:00.000 D0EXBX667X 98.20 0.040

希望A表能从B表中取得小于它时间的最近的时间的那条记录，即最终结果为：
vbeln erdat prdha price rate
0090056842 2009-12-02 00:00:00.000 D0EXBX133X 90.52 0.020
0090058691 2009-12-18 00:00:00.000 D0EXBX133X 95.20 0.080
*/

---

SQL code:
SELECT TOP 1 A.*,B.price,B.rate
from A,B WHERE A.prdha=B.B
ORDER BY ABS(DATEDIFF(SS,erdat1 ,erdat)

---

select a.vbeln,a.erdate,a.prha,b.price,b.rate from  表A a,
(select * from 表B where erdatl=(select max(erdatl)from 表B)) b
where a.vbeln=b.vbeln and a.prdha=b.prdha

---

顶一下！~~回复内容太短了！

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www