Linking 5 tables in 1 new query table :-O

Linking 5 tables in 1 new query table :-O

Hi,

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

TABLE 4 columns (paid transactions data):
- Transaction ID
- Specific data columns

TABLE 5 columns (cancelled transactions data):
- Transaction ID
- 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!!