in SQL / LEFT JOIN - Part II
It seems to me that whether I use m.dept_no or dept_no following 'order by' and 'group by' both have the same result. So my question here is that do I have to specify the m. or d. prefix in codes? Thanks.
1 answers ( 0 marked as helpful)
Thanks for reaching out.
It depends on the task. If in this case the result set is the same, then you can use both.
Hope this helps.