Appending queries
ms-access, mysql, sql
Solution
You would use `UNION`
UNION is used to combine the result from multiple SELECT statements into a single result set.
mysql: http://dev.mysql.com/doc/refman/5.6/en/union.html (Its supported on Access also)
Problem
A quick technical question- I have two queries that output some of the same data. For example, lets say that both queries have column X and Y, and each one has one row with some data in each column. So, we have cell X1 and cell Y1 in each query. How would I go about appending the two queries such that there are still two columns, X and Y, but two rows? Thanks