CREATE VIEW view_name AS SELECT column1, column2, ... FROM table_name WHERE condition;
SELECT customerName, checkNumber, paymentDate, amount FROM customers INNER JOIN payments USING (customerNumber);