Employee History by Job tile and salary JD Edwards

distinct jwan8 Emp#,yaalph Name,yahmcu BU,abalph Supervisor,jmdl01 Title, DATEADD(dy, cast(jwefto as varchar(10)) % 1000, DATEADD(yy, cast(jwefto as varchar(10)) / 1000,-1))EffDate ,yesal/100 Salary,DRDL01 JobCategory fromjde_crp.crpdta.F08042 leftouter join jde_crp.crpdta.F08001 on ltrim(jmjbcd) = ltrim(JWHSTD) leftouter join jde_crp.crpdta.F060119 on jwan8=yean8 and jwefto=yeefto leftouter join jde_crp.crpdta.F060116 on jwan8=yaan8 leftouter join jde_crp.crpdta.F0101 on yaanpa=aban8 LEFTOUTER JOIN jde_crp.crpCTL.f0005 ON DRSY='06' AND DRRT='J' AND LTRIM(YAEEOJ)=LTRIM(DRKY) wherejwdtai='JBCD' and jmjgrp is not null and jwuser<>'kumaraje' --and jwefto>111000 andjwtrs<>'' andyapast in('0','1','2') --and yaan8=106491 orderby 1,3




select