OK I have 3 tables one with products in it, One with the orders in it and join table with the order ids and product ids to associate products with orders.

But how do I set up a query that will select and return all orders as well as the items within each order. So I end up with a column order\_items in each row. 

So far I have:

```
SELECT
  intOrderID AS Order_ID, 
  strPaymentMethod AS Payment_Method,
  strPaymentRef, AS Payment_Ref, 
  strPaymentStatus AS Payment_Status,
  dtmDate AS Date, 
  curPaymentAmount AS Net_Price, 
  curShippingFee AS Shipping_Fee 
FROM tbl_mod_ShopOrders

```

The other table is `tbl_mod_ShopOrderItems` and I need to select 

```
intProductID
strProductTitle
curPrice
intQty 

```

for each item within the order.

I know I need to do some sort of subquery but note sure how to construct it.