I have the following tables:

**Table1**

```
ID  CustomerName       CustomerAddress
1   Joe Bloggs          123 The Street
2   Joe Bloggs Senior   345 The Close
3   Joe Bloggs Jnr      1 The Road

```

**Table2**

```
Table1_ID  Item
1          Toaster
1          Kettle
1          Microwave
3          Toaster
2          Iron
2          Kettle
2          Microwave
2          Slow Cooker

```

What I want, is a list of customers and the other products, they have purchased - if they have purchased a toaster.

I have used the following SQL query.

```
SELECT CustomerName, Item
FROM Table1
LEFT JOIN Table2
  ON TABLE1.ID = TABLE2.Table1_ID

```

which obviously gives me all the items bought by the respective customer.

If I try and put a `WHERE` clause in 

```
SELECT CustomerName, Item
FROM Table1
LEFT JOIN Table2
  ON TABLE1.ID = TABLE2.Table1_ID
WHERE Item = 'Toaster' 

```

I obviously don't get the other items.

I am totally stumped, how to do this.