select * from CIRC.COMPLAINT CM, CIRC.CPT_CATEGORY_DTL CMCAT
where CM.TYPE_COMPLAINT = CMCAT.COMPLAINT_TYPE (+)
I am sorry its dumb question but what does that mean (+) is it a join left outer join or right outer join ??? Is this same as outer join if not does it have any advantage over outer join