Can I combine data from SAGE 100 Job Cost's JobTransactionDetail table and data from Job Cost's JobHistory TransDetail table on the same Crystal Report?

I would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report.

I need to create a summary report that includes data from both tables.  I'm hoping that someone has done something like this (or similar) before. Thanks in advance for any help.