Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2010
    Posts
    6

    Unanswered: Alternative to Union query

    My union query is not running due to exhausting all of my system resources. Does anyone know of alternative to using an union query.

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by gnboston View Post
    Does anyone know of alternative to using an union query.
    sure

    merge your tables into one

    disclaimer: this answer contains as much detailed information as your question

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2010
    Posts
    6
    Actually, I am trying to do a SELF full outer join. I can easily do this in Oracle but not in Access.

  4. #4
    Join Date
    Nov 2010
    Posts
    6
    Thanks for the snarky comment too. Much appreciated.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by gnboston View Post
    Thanks for the snarky comment too. Much appreciated.
    you're welcome

    (you started it)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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