Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    173

    Question Unanswered: joining two results

    I have two sets of results built up. Each set has a state value. Although one set has 38 states in the results while the other has 23. Is it possible to join these sets and show a result for each of the 38 states even if there is not a corresponding value in the other set. All attempts I've made lose the 15 states that do not appear in the other set. Any help would be great. Thanks in advance

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If your database engine supports LEFT JOIN, or better yet FULL JOIN, then you are in business. If not, you can kind of "fake it" using a sub-select, but it is hokey.

    -PatP

Posting Permissions

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