LEFT JOIN sample in SQL

SELECT customers.CustomerName, orders.orderName (you can add more column here with Fully Qualified Name)

FROM customers LEFT OUTER JOIN orders

ON customers.Id = orders.Id;