ÇóÒ»¼òµ¥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