Hi Jimmy,
sorry for the delay. I made the changes. When I confirm the order this is displayed in the browser window:
SELECT orders.language_id, orders.OrderID, orders.OrderReferenceID, orders.OrderShipping, orders.OrderTax, orders.OrderTotal, orders.OrderDate, orders.OrderShipCompany, orders.OrderShipDepartment, orders.OrderShipLastname, orders.OrderShipFirstName, orders.OrderShipAddress1, orders.OrderShipAddress2, orders.OrderShipCity, orders.OrderShipStateID, orders.OrderShipZip, orders.OrderShipCountryID, orders.OrderBillCompany, orders.OrderBillDepartment, orders.OrderBillLastname, orders.OderBillFirstname, orders.OrderBillAddress1, orders.OrderBillAddress2, orders.OrderBillCity, orders.OrderBillStateID, orders.OrderBillZip, orders.OrderBillCountryID, orderdetails.DetailItemID, orderdetails.DetailArticle, orderdetails.DetailItemName, orderdetails.DetailItemDesc, orderdetails.DetailQuantity, orderdetails.DetailPrice, orders.AdditionalInfo FROM orders LEFT JOIN orderdetails ON orderdetails.DetailOrderID = orders.OrderID WHERE orders.language_id = 1 AND orders.OrderReferenceID = -1
