Re: [SQL-MySQL] 關於暫存表的問題
後來自己試驗了好多種方法，
決定還是不要用暫存表，
其實可以直接使用子查詢的方式寫出來。
附上我自己的寫法給各位板友參考，如有問題也請不吝給我一點指導。
SELECT DISTINCT s.Supplier_Name, "->", s.Supplier_Phone, "->", p.Product_Name
FROM `supplier` AS s, `product` AS p
WHERE p.Product_Number IN
(SELECT DISTINCT od.Product_Number
FROM `order detail` od
WHERE od.Order_Number IN
(SELECT o.Order_Number
FROM `order` o
WHERE DATEDIFF(CURDATE(),o.Order_Date) < 181))
AND s.Supplier_Number IN
(SELECT DISTINCT p.Supplier_Number
FROM `product` p
WHERE p.Product_Number IN
(SELECT DISTINCT od.Product_Number
FROM `order detail` od
WHERE od.Order_Number IN
(SELECT o.Order_Number
FROM `order` o
WHERE DATEDIFF(CURDATE(), o.Order_Date) < 181)))
AND s.Supplier_Number = p.Supplier_Number
ORDER BY s.Supplier_Name;
謝謝以前版上的前輩提供一些關於子查詢跟date的用法，
讓我終於可以把我想抓的資料抓出來。Q w Q
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.37.88.115
討論串 (同標題文章)