Combining queries

[betmck]

I hope I am not trying to accomplish an impossible task.. However, I want to combine 2 queries that give different results. Please see attachment with the task I am trying to accomplish showing the queries and the results. Thanks for any suggestions please.

[ranman256]

You want a UNION query... BUT even tho they retrieve different results they MUST have the same COLUMNS. (heading name, no; datatype yes)

select * from qsEquipInUS
union
select * from qsEquipNotInUS