Another possible option would be to make a union query that selects the people, eg:
SELECT [tblA].[Customer Name] FROM [tblA]
SELECT [tblB].[Customer Name] FROM [tblB]
This way you wouldn't have to have a temporary table.
Basically, if you can select the info you need from one table, you can union it with the same sort of thing from the other table
I am a loud man with a very large hat. This means I am in charge