hey,
try this
SELECT A.OPTTYPE ,A.OPTDESC ,
ACCT = CASE WHEN B.ACCTDESC IS NULL THEN G.ACCTDESC ELSE B.ACCTDESC END,
PROJ = ISNULL(C.PROJ,'NA'),
DEPT = ISNULL(D.DEPT,'NA'),
COSTCTR = ISNULL(E.COSTCTR, 'NA'),
WHSEDESC = ISNULL(F.WHSEDESC,'NA'),
A.WHSEID AS WHSEID
FROM INV10221 A right outer join ACT00001_P B on A.ACCT = B.ACCT
Right outer join ACT10001 G on G.CACCT= A.ACCT
Left outer join ACT00004_P C on A.PROJ = C.PROJ left outer join ACT00003_P D
on A.DEPT = D.DEPT left outer join ACT00002_P E on A.COSTCTR = E.COSTCTR
left outer join INV10111 F on A.WHSEID = F.WHSEID
ORDER BY A.OPTDESC
Hope it will help u
Best Luck
Happy Coding :)