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

Clarification

Clarification

0
Votes
1
Answer

video of cross join:
 
where
dm.dept_no <> d.dept_no
 
what does this condition mean?

1 Answer

365 Team
0
Votes

Hi Neelanjan!
Thanks for reaching out and please excuse us for not coming back to your sooner.
<> is the same operator in MySQL as !=, which means “not equal to”. Thus, the condition you’ve mentioned means …here the department number from the table with an alias dm is not the same as the department number from the table with an alias d.
Hope this helps.
Best,
Martin

×
Ready to Learn
Data Science?
50% OFF