Union query (or Inner/Outer join?)

[LilMissAttack]

Hi,

I am having trouble pulling data I want from 3 select queries, I thought I could do this with a Union query but maybe I need some kind of join? This is the first time I've done this so any help would be appreciated....

I have 3 tables, all with the same fields. Each table represents a benefit - Medical, Dental and Vision.

So for instance, John Doe could be on the Medical table and have his coverages listed, but also appear on the dental and/or vision. Jane Doe could be on Vision but not any of the other tables. Another person could be on Dental and Vision....etc.

I need it to pull ALL records and have ALL their info on one line...


But sometimes their address might appear on one table but not the other so I need it to pull that too....

Am I doing this right with a Union Query? Maybe I need some additional SQL (which I barely know anything about?) Right now when I'm pulling it, it gets everyone but has a separate line for Medical, Dental Vision etc.

Thanks for your help!

[weekend00]

you need union plus outer joins. Should be complicated because you have 3 tables and you don't want to miss any one.

[LillMcGill]

create and close a union query
Create a new query. Include the Unionqry and all the tables.
Change all the joins to include all the records from the Unionqry
------------------------------

EDIT: I am too slow!

[LilMissAttack]

Thank you for your answers, it helps so much... forgive me if this is a silly question, but should I be joining all the fields to all the fields in the union query? Sorry I can't seem to wrap my mind around this...
Thanks again

[LillMcGill]

Hopefully, you have a single-field primary key in these tables... join the primary key field in the Unionqry to the primary key in each of the tables.