video of cross join:
dm.dept_no <> d.dept_no
what does this condition mean?
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.