I'm working through the book SQL Cookbook and there's an example where the author uses a query which is purely cosmetic (it's after the first
union all statement):
select ename as ename_and_dname, deptno from emp where deptno = 10 union all select '----------', null from t1 union all select dname, deptno from dept;
t1 doesn't seem to have been defined yet in the text, but let's just assume the table exists and the query produces a single row.) It seems like it could be useful in SQL to have a kind of "empty table" that's a member of every database for performing such queries. In any case, what's the best way of doing this kind of thing?