Web Development

Ask something
Question Locked

Access Query

0 helpful
2 replies

by shari_hamilton

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a question concerning a query I need to create. I am trying to join 3 tables to become one table with the information.

I have two tables with some overlapping data that is employee related with the employee ID as the primary key. I want the end result to be a table with data from both tables that matches overlapping data and appends data that does not overlap.

The employee information in both tables varies, some appears in one and not the other. I want to bring the info from each individual employee into the same column in my table and have their corresponding data associated with them and not duplicate nor overlap.

Can you point me in the direction where I can pull this together? I have created queries and joined two tables but not three and I am not sure which fields I must include from the individual table and where exactly to make the joins to get everything I need.

I would appreciate any help at this point I am so frustrated. I have books but they are not giving me step by step instructions.

2 replies

by locolobo

on the table structures. Is employee ID the only overlapping field between the employee tables?

To try it yourself, think of it this way:

1. Create a two table query that works. It sounds like you already know how you want to join the employee tables.
2. Add the third table to your existing query. What field will you join them on? Start slowly adding only a couple of columns and see how it goes.

Build it from there, adding a little bit at a time. If you can do two table queries you can do three. Give it a try. Let us know how it goes.

This discussion is closed to new replies.