Crosstab with two tables

[kupe]

This is my regular crosstab query, only now it is fed by two tables. Does this mean I have to make a join, please, Experts.

If it does mean a join, I'd be grateful to know where the join is declared.

TRANSFORM Count(qryEmployees.Roots) AS Ethnicity
SELECT qryEmpWorkers.DailyGrind
FROM qryEmployees, qryEmpWorkers
GROUP BY qryEmpWorkers.DailyGrind
PIVOT qryEmployees.Roots;

The key fields are qryEmployees.EmployeeID and qryEmpWorkers.EmployeeIDFK

 

[kupe]

Do you think this is the right way ... and would be accurate?

TRANSFORM Count(qryEmployees.Roots) AS Ethnicity
SELECT qryEmpWorkers.DailyGrind
FROM qryEmpWorkers
INNER JOIN qryEmployees
ON qryEmpWorkers.EmployeeIDFK = qryEmployees.EmployeeID
GROUP BY qryEmpWorkers.DailyGrind
PIVOT qryEmployees.Roots;