1
2        
3            
4        
5     CREATE VIEW customerPayments
6AS 
7SELECT 
8    customerName, 
9    checkNumber, 
10    paymentDate, 
11    amount
12FROM
13    customers
14INNER JOIN
15    payments USING (customerNumber);
16

1
2        
3            
4        
5     SELECT 
6    customerName, 
7    checkNumber, 
8    paymentDate, 
9    amount
10FROM
11    customers
12INNER JOIN
13    payments USING (customerNumber);
14