Gl journal Details

Dear All,

I'm trying to write an SQL query that retrieve the count of transaction for each account :

and 'm comparing the result with the account analyses report that gives the number of transactions for each account

but I have some differences and I assume that I missed one condition because the count of transaction o many accounts match

my query is below:

select

cc.SEGMENT1 || '-' || cc.SEGMENT2|| '-' || cc.SEGMENT3|| '-' || cc.SEGMENT4|| '-' || cc.SEGMENT5|| '-' || cc.SEGMENT6|| '-' || cc.SEGMENT7 Natural_Account,

T.description,

jel.period_name,

count(*) Cnt

from

gl_code_combinations cc,

gl_je_lines jel,