来自第一次查看的结果
我的第二个视图给了我一个错误
我收到错误代码:1054,未知列"V1。V_Name在"关于条款"中
DROP VIEW IF EXISTS vendor_order_times;
CREATE VIEW vendor_order_times AS
SELECT
v.V_NAME as 'Vendor Name',
DATEDIFF(o.O_ARR_DATE, o.O_DATE) as ordertime
FROM vendor v
JOIN product p ON v.V_ID = p.V_ID
JOIN line l ON p.P_ID = l.P_ID
JOIN orders o ON l.O_ID = o.O_ID
GROUP BY o.O_ID
ORDER BY v.V_ID;
DROP VIEW IF EXISTS vendor_shipping_stats;
CREATE VIEW vendor_shipping_stats AS
SELECT
v.V_NAME as 'Vendor Name',
ROUND(AVG(vot.ordertime),1) as 'Vendor: Avg Ship Times',
QueryAuthor() as 'Query Author'
FROM vendor v
JOIN vendor_order_times as vot on vot.V_NAME = v.V_NAME
GROUP BY v.V_NAME
ORDER BY `Vendor: Avg Ship Times` DESC;
在vendor_order_times
视图中,您将V_NAME
字段重命名为 'Vendor Name'
,因此您还需要在第二个视图中使用此名称,或者您需要在vendor_order_times
视图中删除别名。