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 -> outer join question

outer join question

From: matt lewis <matt_at_lewis.co.uk>
Date: Fri, 17 Aug 2007 15:53:33 +0100
Message-ID: <fa4cq0$g2c$1@registered.motzarella.org>


Hi, I'm studying a book which is full of errors and the errata seems sketchy.

Is this statement correct?

"In outer join statements on tables A and B, you specify the left outer join when you want all of table B's rows, even when no corresponding record exists in table A"

I had this down as correct but the answer in the book has it as wrong.

I'm pulling my hair out here!

Is it right or wrong please? Received on Fri Aug 17 2007 - 09:53:33 CDT

Original text of this message

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