Hello, I am trying to join 3 tables: Transactions, Transaction Lines, and TransactionAccountingLines.
The relationship between Transaction ID (from Transactions) can be found in both Transaction Lines and TransactionsAccountingLInes. But, I also see TransactionLineID in the TransactionAccountingLines table. Do i have to join those fields as well?