Query Table Name

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? Received on Mon Nov 03 2008 - 14:55:36 CST