Try it Yourself: SQL Joins

SQL Joins

Language: SQL

SELECT Customers.CustomerName, Orders.OrderID, Orders.Amount
FROM Customers
LEFT JOIN Orders
  ON Customers.CustomerID = Orders.CustomerID;

SELECT Customers.CustomerName, Orders.OrderID, Orders.Amount
FROM Customers
LEFT JOIN Orders
  ON Customers.CustomerID = Orders.CustomerID;

Output

Click Run to execute this code.