SELECT claimedRate FROM tbl_TBA_DistributorData WHERE ClaimID = AND claimedRate > 0 SELECT cl.display_claimid, mfrdst.cdr_dstcode, mfrdst.cdr_dstname, o.MFRCustNum , dd.ProductCode, sum(quantity) quantity, COALESCE(dd.claimedRate,0) Rate , COALESCE(x.contractRate,0) contractRate, SUM(dd.TotalDollars) TotalDollars FROM tbl_TBA_DistributorData dd INNER JOIN tbl_TBA_Claims cl ON (cl.claimID = dd.ClaimID) INNER JOIN tbl_TBA_Contracts c ON (cl.ContractID = c.ContractID) LEFT OUTER JOIN tbl_OPR_ClientOperators o ON (c.Opr_id = o.OperatorID) INNER JOIN tbl_TBA_Distributor d ON (d.dst_dataid = dd.dst_dataid) LEFT OUTER JOIN tbl_CDR_Distributors mfrdst ON (mfrdst.cdr_recordid = d.MFR_dstid) LEFT OUTER JOIN ( SELECT DISTINCT cd1.ProductCode, cd1.ContractRate FROM tbl_TBA_ClaimDetail cd1 WHERE cd1.claimid = ) AS x ON (x.productCode = dd.productCode) WHERE cl.ownerid = AND cl.fsl_tableCode = AND dd.claimid = GROUP BY mfrdst.cdr_dstname, dd.ProductCode, cl.display_claimid, mfrdst.cdr_dstcode , mfrdst.cdr_dstname, o.MFRCustNum, dd.ProductCode, dd.claimedRate, x.contractRate, dd.TotalDollars ORDER BY dd.ProductCode SELECT cl.display_claimid, mfrdst.cdr_dstcode, mfrdst.cdr_dstname, o.MFRCustNum , dd.ProductCode, sum(quantity) quantity, SUM(dd.TotalDollars) TotalDollars FROM tbl_TBA_DistributorData dd INNER JOIN tbl_TBA_Claims cl ON (cl.claimID = dd.ClaimID) INNER JOIN tbl_TBA_Contracts c ON (cl.ContractID = c.ContractID) LEFT OUTER JOIN tbl_OPR_ClientOperators o ON (c.Opr_id = o.OperatorID) INNER JOIN tbl_TBA_Distributor d ON (d.dst_dataid = dd.dst_dataid) LEFT OUTER JOIN tbl_CDR_Distributors mfrdst ON (mfrdst.cdr_recordid = d.MFR_dstid) WHERE cl.ownerid = AND cl.fsl_tableCode = AND dd.claimid = GROUP BY mfrdst.cdr_dstname, dd.ProductCode, cl.display_claimid, mfrdst.cdr_dstcode, mfrdst.cdr_dstname, o.MFRCustNum, dd.ProductCode, dd.TotalDollars ORDER BY dd.ProductCode SELECT productcode, contractrate, rate, variance FROM tbl_TBA_ClaimDetail WHERE ClaimID = ORDER BY productCode SELECT contractrate, rate FROM qry_getCodes WHERE ProductCode = AND Variance = 0 SELECT contractrate, rate FROM qry_getCodes WHERE ProductCode =