Uses for UNION ALL and Views
Right, so yesterday1, I talked about one of the cooler historical SQL hacks out there. Turns out you can (perhaps somewhat incompletely) replicate useful features purely with pure SQL99 (and pure SQL923). There are, in fact, several additional fun ways to use the UNION operator in conjunction with …