view in mysql syntax
snippet in sql

view in mysql syntax

user3035

CREATE VIEW view_name AS

SELECT column1, column2, ...

FROM table_name

WHERE condition; 

query view mysql php

user290


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