can anyone tell me what's the difference between these?
i can tell "union all" is a bit faster... but what is the real difference?