SELECT fsrItem.strProdCode, dwdProduct.strLongProdDesc AS strProductDesc, fsrItem.intQuantityCase, fsrItem.intQuantityBottle FROM fsrItem INNER JOIN dwdProduct ON fsrItem.strProdCode = dwdProduct.strProdCode WHERE (fsrItem.refRequisitionID = @RequisitionID)