Archisman Das
Last answered:

18 Nov 2020

 Posted on:

15 Nov 2020
0

Resolved: Cross Join

  1. What is the significance of the <> operator? { WHERE d.ddept_no <> dm.dept_no }
  2. In the last example, I am not clear with the usage of CROSS JOIN with a JOIN. 
1 answers ( 0 marked as helpful)
Martin Ganchev
Instructor
Posted on:

18 Nov 2020
1
Hi Archisman! Thanks for reaching out.
  1. <> means inequality.
  2. You can follow the logic of joining the given tables sequentially, in the provided order. In other words, you need to first imagine what cross-joining departments and dept_manager in this example. Then, apply an inner join to the obtained output and the employees table. 
Hope this helps.
Best,
Martin

Submit an answer