Re: Query Table Name

From: joel garry <>
Date: Mon, 3 Nov 2008 13:09:13 -0800 (PST)
Message-ID: <>

On Nov 3, 12:55 pm, wrote:
> If you are joining one or more tables, is there a way to know which
> table the value came from?  For example:
> DECODE(<table_name>,value,<table_name>,value,<table_name>,value)........
> FROM a, b, c
>     AND =;
> In this same query, can I get the table name the name of the table the
> value actually came from?

Can you give an example where this works without error? If you are getting an error, care to share? Could the value include the table?


-- is bogus.
Send it home to mother in a cardboard box.
Received on Mon Nov 03 2008 - 15:09:13 CST

Original text of this message