I need to create a query table relating several different tables (all in the same database). This is the specific case:

TABLE 1 columns (transaction data):

- Transaction ID

- Specific data columns

TABLE 2 columns (client data):

- Transaction ID

- Specific data columns

TABLE 3 columns (invoice data):

- Transaction ID

- Specific data columns

- Specific data columns

- Specific data columns

THE RESULT I NEED:

A new query table that lists ALL lines of TABLE 1 plus the columns in TABLE 2 3 4 5 if Transaction ID matches. If tables 2 3 4 5 have additional Transaction IDs not listed in TABLE 1, they should ignored.. my guess is using a multiple LEFT JOIN... but how?

Any help/workaround would be greatly appreciated. I tried to solve this issue for a week :-(

THANKS!!