I have two tables: tblOne and tblTwo with identical categories.
TblOne and tblTwo both group by Category and Duration. When I make a union query between tblOne and tblTwo, I notice that if I have the exact same category and duration for BOTH tblOne and tblTwo, the union query "eats up" one of the identical entries. How can I fix this?

I need to have two different tables because they correspond to two different machines (but are both the same type of machine, hence the identical categories)

I notice that if I have the exact same category and duration for BOTH tblOne and tblTwo, the union query "eats up" one of the identical entries. How can I fix this?Use UNION ALL, instead of UNION.

UNION eliminates duplicate records.

By the way, do they make blue coke?? I remember the crystal clear Coke. I liked it!! :)