Non related tables in a query

[Spruk_77]

Hey all,

Here is my basic table structure

Table 1
SSN
Name
Access

Table 2
IDnumber
Name
Access

Table one is for US citizens and table 2 is for Non US citizens. I would like a query that shows everyone from both tables that has access. The problem I run into is I have multiple results for the same person. Thanks for any help on how to do this.

 

[SunWuKung]

Hi,
I am not sure I understand the table structure. But I will give this a try anyway. If these tables have the same sort of information you could use a union query:

Select 1 AS IsUSCitizen, SSN AS ID, Name, Access From Table_1
UNION ALL
Select 0 AS IsUSCitizen, IDnumber AS ID, Name, Access From Table_2


hth
SWK