《MySQL必知必会》第二十二章-使用视图

用视图简化复杂联结：
CREATE VIEW ProductCustomers AS
SELECT cust_name, cust_contact, prod_id
FROM Customers, Orders, OrderItems
WHERE Customers.cust_id = Orders.cust_id
AND OrderItems.order_num = Orders.order_num;

检索：
SELECT cust_name, cust_contact
FROM ProductCustomers
WHERE prod_id = 'RGAN01';

用视图重新格式化检索出的数据：
CREATE VIEW VendorLocations AS
SELECT Concat(vend_name, ' (', vend_country, ')')
       AS vend_title
FROM Vendors;

用视图过滤不想要的数据：
CREATE VIEW CustomerEMailList AS
SELECT cust_id, cust_name, cust_email
FROM Customers
WHERE cust_email IS NOT NULL;

使用视图与计算字段：
CREATE VIEW OrderItemsExpanded AS
SELECT order_num,
       prod_id,
       quantity,
       item_price,
       quantity*item_price AS expanded_price
FROM OrderItems;