Tables with same information

[Svenne]

Dear listmembers,

Assume the following: I have four tables with names of people. Some of the people that appears in table 1 also appear in the other tables. Is it possible to get a list with the names of the people that ONLY appear in table 1 but not in the other tables?

Best,


Svenne

[Micron]

try "unmatched query" wizard

[Gicu]

To add to Micron's answer, I think the best approach would be to create a new union query on the table 2,3 and 4 to create a unique list of names that exists inthose three queries then create the unmatched query suggested between table 1 and the union query.

Cheers,

[xps35]

In theory that is not too difficult.

SELECT * FROM T1 WHERE
Key NOT IN (SELECT Key FROM T2) AND
Key NOT IN (SELECT Key FROM T3) AND
Key NOT IN (SELECT Key FROM T4)

But............
Why do you store the same data In 4 tables?
How do you know it is the same person?

[Svenne]

Many thanks to all of you for your reply. Much appreciated. Just one more thing. Could you give a step-to-step instruction how to do this? Remember, I am a novice. :-)

[orange]

Svenne,

Remember, I am a novice.

Please provide some info re xps35's questions. We need some context.

Why do you store the same data In 4 tables?
How do you know it is the same person?

[Svenne]

Dear xps 35. With a lot of help from another forum member this worked just great. Thank you so much.

All my best,
Svenne

In theory that is not too difficult.

SELECT * FROM T1 WHERE
Key NOT IN (SELECT Key FROM T2) AND
Key NOT IN (SELECT Key FROM T3) AND
Key NOT IN (SELECT Key FROM T4)

But............
Why do you store the same data In 4 tables?
How do you know it is the same person?

[orange]

Svenne,
Glad you have a working solution.
For the benefit of anyone reading this thread who is experiencing a similar situation.
could you give back a little and address the 2 questions that xps35 posed?

[Svenne]

Svenne,
Glad you have a working solution.
For the benefit of anyone reading this thread who is experiencing a similar situation.
could you give back a little and address the 2 questions that xps35 posed?

I am sorry I didn't notice the questions earlier. It is a completely fictive thing. I was just curious if it was possible to have this kind of list. The names are completely made up by myself.

Once again, many thanks.

[Welshgasman]

Not the data, the logic.