Static Select statements
From: Ubiquitous <weberm_at_polaris.net>
Date: Fri, 28 Mar 2008 15:19:32 -0400
Message-ID: <BZSdnW4lPe9Z2XDanZ2dnUVZ_rOqnZ2d@giganews.com>
Date: Fri, 28 Mar 2008 15:19:32 -0400
Message-ID: <BZSdnW4lPe9Z2XDanZ2dnUVZ_rOqnZ2d@giganews.com>
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 003Received on Fri Mar 28 2008 - 14:19:32 CDT