Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2014
    Posts
    1

    Unanswered: Combining queries

    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.
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    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)
    like:
    select [state],[Code] from tStates where [IsTerritory] = false
    union
    select [state],[Code] from tStates where [IsTerritory] = true

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •