Based on this SQL I have to make a report...
select T1."ACCOUNT" "c1" ,
T4."ACCOUNT" "c5" ,
from "ACCT_DIM" T1,
"ACCT_DIM" T4,
where T6."GL_ACCT_KEY" = T1."ACCT_KEY"
and T6."ACL_ACCT_KEY" = T4."ACCT_KEY"
and T4."ACCOUNT" = '11'
ACL_ACCT_KEY 1,n GL_ACCT_KEY
Everytime I make a join in both columns I see ACCOUNT 11, and so I get only one transaction, I need to see in column 5 '11' and in column 1, many other accounts.
Basically this ACCOUNT column is based on gl_accts and acl_accts
Please someone explain, how do I make this join in Report Studio, i have all these columns in my FM model...
Thank you
Where do you get T6 from?
I don't see it on the "from" part.