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

Home -> Community -> Usenet -> c.d.o.misc -> Outer Join issue

Outer Join issue

From: Steve <stevelaba_at_yahoo.com>
Date: 4 Apr 2007 12:21:39 -0700
Message-ID: <1175714499.874084.288020@y66g2000hsf.googlegroups.com>


Hello all, using 9.2 and can't understand why my join is not working. When I outer join table addr using mn_sale.contracted_cust_id = addr.member_id(+) I get back less rows then if I don't join this table.

I believe I should be getting the same amount of rows that the table mn_sale returns.

Please advise.

Thanks

Steve

SELECT count(1)
 FROM modn.mn_sale mn_sale ,

       modn.mn_address addr ,
       modn.mn_date_dim dt_dim
  WHERE  mn_sale.realm_num       = 1024
     AND     mn_sale.lifecycle_status = 30
     AND     addr.addr_flags                =  1
     AND to_date(dt_dim.short_date_ymd,'YYYY-MM-DD')
    BETWEEN to_date('2006-07-01','YYYY-MM-DD')
     AND           to_date('2006-12-31','YYYY-MM-DD')
     AND mn_sale.sale_type                 <>  1
     AND mn_sale.inv_date_id               = dt_dim.date_dim_id
     AND mn_sale.contracted_cust_id  = addr.member_id(+)
    AND addr.realm_num                      = 1024
Received on Wed Apr 04 2007 - 14:21:39 CDT

Original text of this message

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