JOIN problem/question

[HeartSA]

Here is my query

SELECT [Staff Count].Location, Submitted, [Staff Count] FROM [Staff Count]
LEFT JOIN Submitted ON [Staff Count].[Location] = [Submitted].[Location]

I have another query called Active (field I need is Active) and Resolved
(field I need is Resolved).

What I need to do is add Active and Resolved to the statement. I am kind of
lost

As an example:

Staff Count Submitted Active
Resolved
Location 1 25 6 1
5
Location 2 30 25 3
22
Location 3 12 20 4
16

 

[Guest]

Assuming that the other two queries also have fields called "location" that
allow linking to the first two tables/queries you could write


SELECT [Staff Count].Location, Submitted, [Staff Count], Active.Active,
Resolved.Resolved
FROM (([Staff Count] LEFT JOIN Submitted ON [Staff Count].[Location] =
[Submitted].[Location])
LEFT JOIN Active ON [Staff Count].Location = Active.Location) LEFT JOIN
Resolved ON [Staff Count].Location = Resolved.Location;