作者jengting (~~)
看板Database
标题Re: [SQL ] 请问O是指甚麽?
时间Mon Apr 8 20:20:02 2013
这样写应该比较不容易误会 ~~
SELECT O1.*
FROM PRODUCT P
FULL JOIN ORDERS O1 ON O1.PRODUCTID = P.PRODUCTID
WHERE O1.ORDERDATE =
(
SELECT MAX(ORDERDATE)
FROM ORDERS AS O2
WHERE O2.PRODUCTID = O1.PRODUCTID
)
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 61.62.188.133