I am new to access and I don't know what is going on..may be you guys can help!
SELECT qry000OrderDetailList.*, qryLstOrderProducts.ProductID,qryLstOrderProducts. ProductTypeID,
qryLstOrderProducts.LanguageID,qryLstProducts.Prod uctName,
qryLstOrderProducts.ProdctDescription,qryLstOrderP roducts.UnitsInStock,
qryLstOrderProducts.UnitsOnOrder,qryLstOrderProduc ts.WhseStock,qryLstOrderProducts.QtyOut,
qryLstOrderProducts.QtyRet,qryLstOrderProducts.Pro ductType,qryLstOrderProducts.Language,
qryLstOrderProducts.IncludePR,qryLstOrderProducts. IncludePT,qryLstOrderProducts.IncludeLG
FROM qry000OrderDetailList INNER JOIN qryLstOrderProducts ON qry000OrderDetailList.OrderID=qryLstOrderProducts. OrderID;