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.
you want a UNION query. (it must be built in SQL mode ,not the visual grid)
Both queries must have the same # columns (and datatypes respectively)
select [state],[Code] from tStates where [IsTerritory] = false
select [state],[Code] from tStates where [IsTerritory] = true