Database Query help

[Fraser]

I'm using MS Access and have two lists of users in two different tables but I want to run a query and get one combined list of users. Some might be in both tables but there are certain users that are only in one table or the other.

In some ways I don't think this is difficult but I can't quite get my head round how to do this in one query in access. Any advice?

An example table layout is

Table 1

id | user
----------
1 | abc
2 | def
3 | ghi

Table 2

id | user
----------
1 | abc
4 | jkl
5 | mno
2 | def

[Tony Harrison]

use UNION.

Example:

select id, user from table1
union
select id, user from table2

Important to remember that with unions all columns must be of the same datatype (vertically).

You may want to have a look at your table structure, as if you get into that sort of situation you probably have a badly designed database.

[Fraser]

ahh! That's the one - thanks

It is possible that it's not the best design of tables but at the moment I'm just picking up someone else's project and trying to get the right reports out of it so for the time being I'll let it go!