I have two tables, and I made a union query (tbl1 UNION ALL SELECT ...tbl2). Problem is, I have two entries that are identical in both tbl1 and tbl2, but I want to include BOTH of them in the union query. Even though I used the ALL operator, only one set shows up!! I'm pulling out my hair trying to figure this out. Please help, and thanks so much in advance!:(

?? If they are identical how do you know which table the record comes from?

?? If they are identical how do you know which table the record comes from?

It doesn't matter because the calculations are made from the records themselves, regardless of which table it came from.

I figured out a solution by making a query by "union-ing all" the two full tables, and then adding calculations in on the unionized query.

Thanks for your help!