What I need is to show which personnel have completed ALL of the trainings required for a position, as well as who has started the process and what trainings are left to complete
What signifies training required for Position?
How do you determine Position? Is that EOC Position? We only know what you tell us, so clarity/completeness is key.
What does Agency mean with respect to Position?
Does this query identify all Training for Each Position? It shows 1119 Position*training combinations.
Code:
SELECT
[EOC Positions].Position
, [Credential Training].Requirement
FROM
[EOC Positions] INNER JOIN [Credential Training]
ON [EOC Positions].ID = [Credential Training].Position;
What does this requirement really mean ICS-200/IS-200?