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.