Join a granular table to summary table without adding rows to Generic Inquiry

Hi Acumatica,

My objective is to join the subaccount field on the APTran table to a GI at the APInvoice level. If there are multiple different subaccounts, just join the first one available. The current issue I am having now is that any kind of join between the APTran and APInvoice tables result in addition of rows to the APInvoice generic inquiry.

What is the simplest way for me to join the subaccount field from the more granular APTran table onto the less granular APInvoice level without adding rows to the APInvoice?

Thank you,