xxxxxxxxxx
CREATE VIEW view_name AS
SELECT column1, column2column N
FROM table1, table2table N
WHERE condition;
xxxxxxxxxx
CREATE VIEW order_details AS
SELECT Customers.customer_id, Customers.first_name, Orders.amount
FROM Customers
JOIN Orders
ON Customers.customer_id = Orders.customer_id;