Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Determine source-table from field within join?

Determine source-table from field within join?

From: dean <deanbrown3d_at_yahoo.com>
Date: Mon, 13 Aug 2007 07:49:24 -0000
Message-ID: <1186991364.626727.7810@19g2000hsx.googlegroups.com>


10g.

How can one tell which table a field in a query comes from? For example a join between tables A and B contains 10 fields (F1 to F10), 5 from A and 5 from B. How would one tell if field F1 is from A or B? Is there a SQL-parsing system view? Received on Mon Aug 13 2007 - 02:49:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US