作者danlin1012 (玺朵站岗中Q Q)
看板Database
标题Re: [SQL-MySQL] 关於暂存表的问题
时间Tue Jan 19 15:27:10 2010
後来自己试验了好多种方法，
决定还是不要用暂存表，
其实可以直接使用子查询的方式写出来。
附上我自己的写法给各位板友参考，如有问题也请不吝给我一点指导。
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