Compare Costs between Cost Methods

SELECT
trim(a.COMCU) as BP,
trim(a.COLITM) as GLOBAL_ITEM#,
trim(a.coaitm) AS LEGACY_ITEM#,
(a.COUNCS/10000) "01",
b.councs/10000 as "02",
c.councs/10000 as "07"
FROM qaDTA.F4105 a, qadta.f4105 b, qadta.f4105 c
WHERE a.colitm = b.colitm
and a.COmcu = b.comcu
and a.colitm = c.colitm
and a.comcu = c.comcu
and b.colitm = c.colitm
and b.comcu = c.comcu
and a.coledg = '01'
and b.coledg = '02'
and c.coledg = '07'
and a.comcu = '     3110082'