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 -> Re: Strange question

Re: Strange question

From: Gump <phefford_at_gmail.com>
Date: 10 Mar 2005 20:47:19 -0800
Message-ID: <1110516439.680427.325710@o13g2000cwo.googlegroups.com> 





I'm confused...



The stated question is "A SQL query cannot display data from table B
that is referred to in its subquery, unless table B is included in the
main query's FROM clause".



The stated answer is "FALSE".



You have produced a SQL query that proves that stated answer is
correct.  That is, you CAN display data from table B that is referred
to in its subquery where table B is NOT included in the main query's
FROM clause.



???
Received on Thu Mar 10 2005 - 22:47:19 CST












Original text of this message













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