Join multiple tables to one

[b6677862]

Good time of day!


Suggest how to implement the following query in Access 2003?

SELECT *
FROM Table1
LEFT JOIN Table2
ON Table1.PK = Table2.FK

LEFT JOIN Table3
ON Table1.PK = Table3.FK

LEFT JOIN Table4
ON Table1.PK = Table4.FK

That is, the need to obtain a summary report in which for each record from Table1 will be all the records from Table2, 3, 4, including empty ones.

[aytee111]

What is the actual problem - the joins or getting a summary?