There are only two tables. So, if you place the field of contact table on the left hand side of your query, then it should be left outer join.
i.e. say, if you join as
contact.emplid = course.emplid, then it has to be contact.emplid (+) = course.emplid, in Oralce.
In generic SQL, it can be written as :
select * from contact
left outer join course on
contact.emplid = course.emplid
Bookmarks