The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Cross Join

Cross Join

Super Learner
0
Votes
1
Answer
  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 Answer

365 Team

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

×
Online Data Science Training
SAVE 60%