Nam V. Do
Nam V. Do
Programming language:PHP
2021-04-10 01:44:49
0
Q:

left join php

ko x
ko x
Code: PHP
2021-03-19 16:13:48 
/*Two tables: CUSTOMERS table and ORDERS table.
ORDERS table contains STATUS attribute.*/
SELECT 
    customers.customerNumber, 
    customerName, 
    orderNumber, 
    status
FROM
    customers
LEFT JOIN orders ON 
    orders.customerNumber = customers.customerNumber;
5
Jack
Jack
Code: PHP
2021-01-19 11:34:37 
SELECT 
    Student_details.*,
    Attendance.*
FROM
    Student_details
LEFT JOIN Attendance ON 
    Student_details.s_id = Attendance.s_id;
0
Barbara Pająk
Barbara Pająk
Code: PHP
2021-08-13 10:00:43 

 SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;
1

Tags

Related

New to Communities?

Join the community