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