RE: Need Good OUTER Join

Title: RE: Need Good OUTER Join What's wrong with the output you see? Do you not like the results because you are seeing rows where u.user_id is != 5 ? -Original Message- From: Woody McKay [mailto:[EMAIL PROTECTED]] I'm having trouble figuring out the proper Outer join (duplicate

RE: Need Good OUTER Join

Title: RE: Need Good OUTER Join Hello all, 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

RE: Need Good OUTER Join

Title: RE: Need Good OUTER Join The problem is there are duplicate data for the page_id and page_title. -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 15, 2001 2:11 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Need