Hi folks. This is a quickie, but potentially nasty: Imagine a table query, returning a given number of rows. Now, add an outer join to another table and return a column from that other table. NO additional query predicates other than the outer join one. Is there any way the number of rows returned from the query would change? AFAIK, an outer join does NOT add or subtract rows from a result set. True? -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxxxxx ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------