Results 1 to 2 of 2
  1. #1
    jachbow is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2021
    Posts
    4

    Combining Queries


    Hi all,

    I am trying to merge 2 queries. For example, query A has one column with letters and query B has one column with numbers; how do I make a third query that has TWO columns, one from each query. I am not really familiar with SQL and mainly use Access's visual tools, but I did try using UNION which returned a third query with ONE column with info from both queries (letters and numbers). Is UNION the correct thing to use and I am just doing it wrong or is there something else that would make the process easier?

    Thank you.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,653
    UNION is like appending and only works where the number of fields used from each source is the same.
    Use the query builder, add your 2 queries the same as you would tables. Create whatever joins you need between the two queries, even if that is on 2 or more fields that are not included in the results.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Combining Two SQL Queries
    By robsmith in forum Access
    Replies: 2
    Last Post: 03-19-2020, 04:10 AM
  2. combining 2 queries
    By sdel_nevo in forum Queries
    Replies: 2
    Last Post: 07-23-2014, 04:41 AM
  3. Combining two queries.
    By Ray67 in forum Queries
    Replies: 1
    Last Post: 09-07-2012, 12:11 PM
  4. Combining two queries
    By Adele in forum Queries
    Replies: 1
    Last Post: 07-16-2011, 12:17 AM
  5. Combining Two Queries
    By csolomon in forum Queries
    Replies: 1
    Last Post: 09-03-2009, 01:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums