Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    11

    Angry Unanswered: Unioning 2 queries with OR statement

    I have 3 queries. The first two I can combine with a union query. Then I need to take that union query and combine it with my third query but I need to combine them with an OR statement. I already tried the following SQL

    (SELECT CustID FROM Myunionquery) OR (SELECT CustID FROM Mythirdquery);

    Why isn't this working?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What you have listed looks like it's a criteria, not a result set.

    If you intend to combine them, why not use another union query?

  3. #3
    Join Date
    Apr 2004
    Posts
    11

    a little more complicated

    It's a little more complicated than just another union. I figured something else out though to work around it. :-) I talked them out of doing it that way. :-)

Posting Permissions

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