SELECT cl.display_claimid, mfrdst.cdr_dstcode, mfrdst.cdr_dstname, o.MFRCustNum , dd.ProductCode, sum(quantity) quantity 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 = --and dd.productCode IN ('02559','04280','04300','04549','07333','10778','35300') GROUP BY mfrdst.cdr_dstname, dd.ProductCode, cl.display_claimid, mfrdst.cdr_dstcode, mfrdst.cdr_dstname, o.MFRCustNum, dd.ProductCode 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 = SELECT contractrate, rate FROM qry_getCodes WHERE ProductCode = AND Variance = 0

cdr_dstname	ProductCode	quantity	Rate	claimed rate	claimed dollars	contract rate	contract dollars	Total
	#qDstData.ProductCode#	#qDstData.quantity#	#qDstData.rate#		#variables.GrpClaimTotal#		#variables.GrpContractTotal#	#dollarformat(val(variables.GrpClaimTotal - variables.GrpContractTotal))#
							Total:	#dollarformat(variables.qTotal)#

--->