Alternate way Outer Join
select e.empid, d.deptname from employee e left outer join department d on e.deptid = d.deptid select e.empid, d.deptname from employee e, department d on e.deptid *= d.deptid
IF the start is left then it is left outer join
if the star present in right then it is right outer join.
Alternate way of Outer Join was last modified: October 1st, 2017 by