Re: Query Table Name

From: ddf <>
Date: Mon, 3 Nov 2008 13:12:26 -0800 (PST)
Message-ID: <>

On Nov 3, 2: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?

I don't really understand what you've done with this ... err .... 'query'. Is <table_name> a stored value? Or is it your representation of the actual table name?

You'll need to describe this 'problem' in more detail than you have to get any sort of usable response, I think.

David Fitzjarrell Received on Mon Nov 03 2008 - 15:12:26 CST

Original text of this message