I am creating a document with 3 tables and am struggling with joining them together properly.
The tables are:
Accounts - with account level detail
Cards - with debit card level detail like card number (one to many relationship with accounts but not all accounts have cards)
Transactions - transaction level detail (one to one relationship with cards but not all transactions are made with cards and many to one relationship with accounts but not all accounts have transactions)
The Cards table needs to join to the accounts table via Account Number and Date without duplicating accounts
The Transactions table needs to join to the Accounts table via Account Number and Date without duplicating accounts
The Transactions table and Cards table need to join together via Date and Card Number but not all transactions are made with a card
Does anyone know what this join would look like?
If I left join cards to accounts it duplicates the accounts with as many cards that are on the account.
Thanks
