Re: [SQL ] Oracle 的問題

[fantasyj (如夢似幻)]

Sorry, 我會錯意了, 再次修改, 不過這必須是PONo是Unique才行

SELECT D.PartNo
      ,D.PartName
      ,P.PurcDate
      ,(SELECT L.PurcPrice
          FROM POList L
         WHERE L.POno = P.POno) PurcPrice
      ,L.PurcPice
  FROM PartData D
      ,(SELECT L.PartNo
              ,L.PONo
              ,MAX(P.PurcDate) PurcDate
          FROM PO P
              ,POList L
         WHERE P.PONo = L.PONo
      GROUP BY L.PartNo
              ,L.PONo) P
 WHERE D.PartNo = P.PartNo (+);


 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.117.123.203
推 passersby:這個PurcDate不是唯一 而且沒辦法抓最新的PurcPrice
推 passersby:不過還是謝謝你 :)
※ 編輯: fantasyj        來自: 59.117.123.203       (11/08 18:10)
推 passersby:我丟進去他吐ORA-01427給我QQ
→ fantasyj:那就是你POno不是唯一..