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 * FROM productCustomers;