>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...
It looks like your missing a join condition between TR2 and GL Master, so your probably getting the same GLMST_NAME in both columns?
what about something like...
WHERE TRANS_CODEFK=GLMST_CODEPK ;
AND TRANS_KEYPK=TR2_KEYFK ;
AND TR2_CODEFK = GLMST_CODEPK
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos