Extracting report from journal table and transaction date from expense table

Hi all,

Has anyone ever try to make a report from Query manager when the source table is JRNL_HEADER , JRNL_LN and EX_SHEET_LINE ?

I try to make a report with JRNL_HEADER and JRNL_LN as main table and add transaction date information from EX_SHEET_LINE but I can't find a unique key to link between those tables so that I can add Transaction date for each transaction in the journal that has been generated.

I try to use JRNL_LN_REF and AMOUNT from JRNL_LN table and link it with SHEET_ID and MONETARY_AMOUNT in EX_SHEET_LINE table but still stuck in a problem if there's 1 SHEET_ID having same amount but different Transaction date.