I have two tables: employee and department. The employee table has a foreign key dep_id pointing to the primary key, dep_id, of the department table.
Outer Left Join: SELECT d.name, e.name FROM department d, employee e WHERE d.dep_id = e.dep_id (+);
Do I get a Outer Right Join by just switching the sides on equal sign (=) like following?
SELECT d.name, e.name FROM department d, employee e WHERE e.dep_id (+) = d.dep_id;
They are both valid SQL statements. I guess the result set should be the same. Correct?