Please could someone assist?

You must write
Select Orders.*, Products.* FROM Orders INNER JOIN
(OrderDetails INNER JOIN Products ON
(Prodcts.ProductID = OrderDetails.ProductID) ON
(Orders.OrderID = OrderDetails.OrderID)
Where OrderDetails.orderid="&orderid&" and not processed"
Otherwise you get only the items from the Orders Table

Good luck

Hswes