I have 3 tables `Order`, `CheckoutStatus`, and `Statuses`. There is a foreign key in `Order` and `CheckoutStatus` that references the `Statuses` table.

I need to join `CheckoutStatus` to `Order` linked by the `PO` column and I need to join `Statuses` to `Order` and to `CheckoutStatus`.

**Here is the data in the tables**

Order table

```
`PO` = 123456
foreign key `Statuses_id` = 2

```

CheckoutStatus

```
`PO` = 123456
foreign key `Statuses_id` = 0

```

Statuses

```
`id` 0 = Complete
`id` 2 = Completed

```

How do I write my SQL statement so that I can have a result like this.

```
Order
123456
Completed
CheckoutStatus
123456
Complete

```

This SQL statement I'm using does not display anything unless I remove one of the `JOIN Statuses` section of the statement.

```
SELECT * FROM `Order` JOIN `Statuses` ON Statuses.id = Order.Statuses_id JOIN `CheckoutStatus` ON Order.PO = CheckoutStatus.PO JOIN `Statuses` ON Statuses.id = CheckoutStatus.Statuses_id

```