Re: Query Table Name
Date: Mon, 3 Nov 2008 13:09:13 -0800 (PST)
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),
> 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?
-- @home.com is bogus. Send it home to mother in a cardboard box.Received on Mon Nov 03 2008 - 15:09:13 CST