Re: Query Table Name

On Nov 3, 12:55 pm, artme..._at_gmail.com wrote:
> If you are joining one or more tables, is there a way to know which
> table the value came from?  For example:
>
> SELECT DISTINCT(id),
> DECODE(<table_name>,value,<table_name>,value,<table_name>,value)........
> FROM a, b, c
> WHERE a.id = b.id
>     AND a.id = c.id;
>
> 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?

jg

--
@home.com is bogus.
Send it home to mother in a cardboard box.