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: Outer join with constants

Re: Outer join with constants

From: LJQ <laojiqi_at_hotmail.com>
Date: 19 Sep 2004 03:16:46 -0700
Message-ID: <84555688.0409190216.874be90@posting.google.com> 





Thanks.



I as using Oracle9i Enterprise Edition Release 9.2.0.1.0 for HPUX and
Windows.



Outer join supposes to handly the relation with 2 tables, how does
ANSI (SQL99) define this (join two contants with no relation on the
target tables)? The standards only say that the JOIN ON clause using
the same syntax with where clause but it does not give the expected
result.



I have checked the FIXED BUG list for 9.2.0.5.0 as well, it does not
mention this one.
Received on Sun Sep 19 2004 - 05:16:46 CDT












Original text of this message













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