I came across some code and I'm trying to understand unions in SQL.
The code has two select statements between a union. The two select statements are on the same table.
Isn't that a bad use of a union? Shouldn't unions between different tables with like data?
Just trying to understand theory. I can't post examples as they are proprietary.