Help with JOIN

[masha2008]

Based on this SQL I have to make a report...

Code Select Expand

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

[VisioX]

Where do you get T6 from?
I don't see it on the "from" part.