On Mon, 31 Mar 2008 05:03:21 -0400, Ubiquitous <weberm@[EMAIL PROTECTED]
>
wrote:
>bigbuck714@[EMAIL PROTECTED]
wrote:
>>On Mar 28, 3:19 pm, Ubiquitous <web...@[EMAIL PROTECTED]
> wrote:
>
>>> 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
>>
>>This should work:
>>
>>Select 'A' as 'TABLE', name, recno
>>from a
>>UNION
>>select 'B' as 'TABLE', name, recno
>>from b
>
>Thank you! That's exactly what I was seeking!
>The 'TABLE' literal should be enclosed with double quoyes ("), however.
Incorrect.
Sybrand Bakker
Senior Oracle DBA
|
