SELECT c.title, c.contractid, cl.display_ClaimID, o.CompanyName, o.mfrCustNum, cl.Invoice, cl.InvoiceDate , COALESCE(cl.InvoiceAmt,0) AS InvoiceAmt, cl.InvoicePerDesc, a.attrDescription ,cl.CheckReqDate , cl.PaymentDate, cl.CheckDate, cl.CheckNumber, cl.checkamount FROM tbl_TBA_Contracts c, tbl_OPR_ClientOperators o, tbl_TBA_Claims cl, tbl_TBA_Attributes a WHERE c.OwnerID = 1 AND c.FSL_TableCode = 'MFR' AND c.opr_id = o.operatorid AND c.contractid = cl.contractid AND cl.PaymentStatus = a.attrID ORDER BY c.title, cl.invoiceDate desc #variables.RowData#