Query to show two types of employee training

[SusanCB]

Help! I'm trapped in query hell!

My database has three tables: People, Agency Training, and External Training. I want to be able to create a report showing each person and both their Agency and External trainings.

I can run queries that give me a person's Agency training or their External training -- but not a single query that does both.

Some details on my relationships:

People.ID is joined to External.Trainee.

People.ID is joined to Agency.ID.

I tried joining External.Trainee to Agency.ID, but that gave me nothing but blank results.
​

Is this enough information to figure out what I'm doing wrong? Thanks for any advice. (Clearly I am new at this, so have mercy on me.)

 

[llkhoutx]

Try a union query, i.e. people-agency union people-external.

 

[boblarson]

And you probably shouldn't have two different tables for training, but just a field to indicate which it is.

 

[SusanCB]

Thanks, llkhoutx and Bob. The union query worked perfectly (and hey, now I know how to create one!).

I'd initially had both types of training in one table but the data is so different that things got unwieldy.