Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
Select DISTINCT top 1000 cmp.cmpname, ins.first, ins.last, bp.Amount, ccc.amount, ccc.authorization, ccc.transaction, ben.description, ccc.updateDT from creditCardCharge ccc INNER JOIN insured ins ON ccc.empid = ins.empid INNER JOIN employee emp ON ccc.empid = emp.empid INNER JOIN company cmp ON emp.cmpid = cmp.cmpid INNER JOIN insuredBenefit ib ON ccc.empid = ib.empid INNER JOIN benefitPayment bp ON ib.ibid = bp.ibid INNER JOIN benefitPaymentBatch bpb ON bp.bpbid = bpb.bpbid INNER JOIN benefitCoverage bc ON ib.bcid = bc.bcid INNER JOIN benefit ben ON bc.benid = ben.benid ORDER BY ccc.cccupdateDT DESC
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!