Let's learn Cross Join!

CROSS JOIN

HR manager to data analyst: Bring me the every possible combination of department ids and job ids along with the details for both. Data analyst runs below query to fetch the data. 

SELECT * FROM DEPARTMENTS, JOBS;