Views in mysql

This article is tagged with: Views in mysql and mysql

mysql views

CREATE VIEW customerPayments
AS
SELECT
customerName,
checkNumber,
paymentDate,
amount
FROM
customers
INNER JOIN
payments USING (customerNumber);

views in mysql

views in mysql

This article is tagged with: Views in mysql and mysql