How to use Jet Report to pick up AA information

I am trying to use Jet to reconcile projects from Analytical Accounting.

Under the "Account Transactions" table, there is no AA related information . The only "key" I found that between "Account Transactions" and "AA Transactions" table is "Account Number". How should I use the "key" to create the report? How to combine to different source (table) in one Jet report? Any help is greatly appreciate.

Thanks,
Louise