Combining two tables into one table

[Guest]

Hi,

I have several tables each relating to different sections of a
questionnaire, all these tables contain the 'Employee ID' as there primary
key, however not all sections (tables) contain all ID's.

Therefore, how can i combine these tables into one complete table, with one
row for each employee ID with all the different sections contained in that
single row for each employee, because with an append it creates several rows.

hope this is clear

Thanks in advance

 

[Amy Blankenship]

Sounds like what you want is not a table, but a crosstab query.

HTH;

Amy

 

[Guest]

The other thing you may try is a "union" query

 

[Guest]

hi thanks for your responses, but unfortunately a crosstab query won't work
because i have around 50 questions (columns) in total, each which a rabge of
answers. How and what is the SQL code for the Union query i need?

thanks

 

[Duane Hookom]

Why don't you provide some sample records with sample fields so we can
understand your question better? I think you only need to use LEFT or RIGHT
JOINS but it is difficult to understand.

A union query could create a normalized result where each answer to each
question becomes a record rather than a separate field.