Static Select statements

From: Ubiquitous <>
Date: Fri, 28 Mar 2008 15:19:32 -0400
Message-ID: <>

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?

----- ---- ----

A     Bob  001
A     Tim  002
B     Joe  001
A     Sue  003
Received on Fri Mar 28 2008 - 14:19:32 CDT

Original text of this message