Re: [SQL ] 請問O是指甚麼?

[jengting (~~)]

這樣寫應該比較不容易誤會 ~~

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