When I currently append query B to query A, it leaves me with a query A that just has query B values added on to the bottom. What I'm looking to do is to combine query A and query B in a way that would give me a new query C with both A and B values in it, but would then also leave me with a separate query A and query B. I'd really like to keep individual versions of A and B just from an organizational perspective.
I've thought about making a copy of query A and then appending to that, but the problem there is that if I make changes in the original non-appended version of query A, the changes won't be reflected in the copied version that has B appended to it. However, if I make changes to query B, those changes would be reflected in the copied version of A.
So the question is: Is there a way to append/combine two queries into one new query while keeping individual versions of the original two queries? Thanks!
