| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Outer Join issue
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
![]() |
![]() |