Will there be any issue if we interchange tables like below code
Will there be any issue if we interchange tables like below code
SELECT
m.dept_no, m.emp_no, m.from_date, m.to_date, d.dept_name
FROM
departments_dup d
JOIN
dept_manager_dup m ON m.dept_no = d.dept_no
ORDER BY m.dept_no;
3 answers ( 0 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Hi,
It shouldn't be any issues.
I searched for it and found that it isn't a issue if we use just JOIN, but if we are using LEFT or RIGHT JOIN then this is issue as explained in lectures.
Hi Muhammad!
Thanks for reaching out.
The order of the tables does not matter as David pointed out. The order matters only when using LEFT / RIGHT JOIN.
Hope this helps.
Best,
Tsvetelin