gistfile1.sql

mysql> select * from `Customer` c  JOIN (`Order` o) on (c.CustomerID=o.CustomerID) order by c.CustomerID;
+------------+-----------+---------+------------+-----------+
| CustomerID | Name      | OrderID | CustomerID | OrderItem |
+------------+-----------+---------+------------+-----------+
|          1 | Nathan    |       1 |          1 | boots     |
|          2 | James     |       5 |          2 | shirt     |
|          2 | James     |       2 |          2 | socks     |
|          3 | Brauer    |       6 |          3 | scarf     |
|          3 | Brauer    |       3 |          3 | pants     |
|          4 | The First |       4 |          4 | shorts    |
+------------+-----------+---------+------------+-----------+
6 rows in set (0.00 sec)

    mysql> select * from Customer c left outer JOIN (`Order` o) on (c.CustomerID=o.CustomerID) order by c.CustomerID;
    +------------+-----------+---------+------------+-----------+
    | CustomerID | Name      | OrderID | CustomerID | OrderItem |
    +------------+-----------+---------+------------+-----------+
    |          1 | Nathan    |       1 |          1 | boots     |
    |          2 | James     |       5 |          2 | shirt     |
    |          2 | James     |       2 |          2 | socks     |
    |          3 | Brauer    |       6 |          3 | scarf     |
    |          3 | Brauer    |       3 |          3 | pants     |
    |          4 | The First |       4 |          4 | shorts    |
    |          5 | Cheeser   |    NULL |       NULL | NULL      |
    +------------+-----------+---------+------------+-----------+
    7 rows in set (0.00 sec)