Resolved: Any difference if changing the order of the tables around CROSS JOIN

Question

Instead of the query you suggested in the solution, I ran the following, and got the same answer, I just wanted to make sure if the tables order matter with CROSS JOIN.

Thanks

SELECT
    m.*, d.*
FROM
    dept_manager m
        CROSS JOIN
    departments d
WHERE
    d.dept_no = 'd009'
ORDER BY m.emp_no;

Answer 1

Hi Saeed!
Thanks for reaching out.

In the case where you use JOIN (INNER JOIN) and CROSS JOIN the order does not matter. But if you have LEFT JOIN or RIGHT JOIN the table order matters!

Note: Actually JOIN is the same as INNER JOIN.

Hope this helps.
Best,
Tsvetelin

Resolved: Any difference if changing the order of the tables around CROSS JOIN

Submit an answer

related questions