I've attempted to write a query but I've not managed to get it working correctly.

I'm attempting to retrieve where a specific product has been bought but where it also has been bought with other products. In the case below, I want to find where product A01 has been bought but also when it was bought with other products.

Data (extracted from tables for illustration):

```
Order | Product
123456 | A01
123457 | A01
123457 | B02
123458 | C03
123459 | A01
123459 | C03

```

Query which will return all orders with product A01 without showing other products:

```
SELECT
O.NUMBER
O.DATE
P.NUMBER

FROM
ORDERS O
JOIN PRODUCTS P on P.ID = O.ID

WHERE
P.NUMBER = 'A01'

```

I've tried to create a sub query which brings back just orders of product A01 but I don't know how to place it in the query for it to return all orders containing product A01 as well as any other product ordered with it.

Any help on this would be very grateful.

Thanks in advance.