Is there a way to force a static row in a SELECT statement?
For example, I have a SELECT statement which is a UNION of two identical
tables, "A" and "B". How would one create a column which identifies the
source
table?
TABLE NAME REC#
----- ---- ----
A Bob 001
A Tim 002
B Joe 001
A Sue 003
