Clarification
video of cross join:
where
dm.dept_no <> d.dept_no
what does this condition mean?
1 answers ( 0 marked as helpful)
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
Martin