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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Need Good OUTER Join

RE: Need Good OUTER Join

From: Woody McKay <wmckay_at_hydrogenmedia.com>
Date: Thu, 15 Nov 2001 13:04:41 -0800
Message-ID: <F001.003C6B0F.20011115123027@fatcity.com>

The
problem is there are duplicate data for the page_id and page_title.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Jacques Kilchoer   [mailto:Jacques.Kilchoer_at_quest.com]Sent: Thursday, November 15,   2001 2:11 PMTo: Multiple recipients of list   ORACLE-LSubject: RE: Need Good OUTER Join   What's wrong with the output you see? <FONT   size=2>Do you not like the results because you are seeing rows where u.user_id   is != 5 ?
>-----Original Message----- <FONT

  size=2>>From: Woody McKay [<A
  href="mailto:wmckay_at_hydrogenmedia.com">mailto:wmckay_at_hydrogenmedia.com]
> >I'm having trouble figuring

  out the proper Outer join (duplicate titles) for the following:
>I need a list of all the page_id (id's) and
  page_title (titles) from PAGES along with the security_id from USERS_X_PAGES   where the user exists.  USERS_X_PAGES may or may not have any   records.  Below is my current query and table layout.   <FONT

  size=2>>======================================================================= 

>  1  select p.page_id,

  substr(p.page_title,1,30), p.page_parent_id, x.security_id <FONT   size=2>>  2  from pages p, users_x_pages x, users u
>  3  where p.page_id = x.page_id(+)
>  4  and x.user_id = u.user_id(+)
>  5  and u.user_id(+) = 5
>  6* order by page_title <FONT

  size=2>>SQL> / >   PAGE_ID
  SUBSTR(P.PAGE_TITLE,1,30)      PAGE_PARENT_ID   SECURITY_ID >---------- Received on Thu Nov 15 2001 - 15:04:41 CST

Original text of this message

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