/*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;
SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;
SELECT Student_details.*, Attendance.* FROM Student_details LEFT JOIN Attendance ON Student_details.s_id = Attendance.s_id;