query view mysql php
snippet in sql

query view mysql php

user7456


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

query view mysql php

user6095


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

views in mysql

user7209

views in mysql