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;