I'm having 3 files :-

1. GL Master - Having all the general Ledger codes
2. Trans - Having Debit Part of Entry - Parent of Tr2
3. Tr2 - Having Credit Part of entry - Child of Trans

Both Trans and Tr2 are taking G/L Code, G/L Desc etc. from GL master, I'm using following SQl to generate report but it is not returning correct Glmst_name for tr2...

SELE TRANS_VNO, TRANS_DATE, TRANS_CODEFK, GLMST_NAME, TRANS_PART, TRANS_AMT, ;
TR2_CODE, GLMST_NAME, TR2_PART, TR2_AMT ;
FROM ACTRANS, ACGLMST, ACTR2 WHERE TRANS_CODEFK=GLMST_CODEPK AND ;
TRANS_KEYPK=TR2_KEYFK

Can somebody give me the correct sql to get the right Glmst name...