Resolved: Why don't aliases work?
3 answers ( 1 marked as helpful)
Hi Mohamed!
Thanks for reaching out.
It is because there is no such a column in the dept_manager table. The dept_name column is in the departments table. So, you should use d.dept_name instead of dm.dept_name.
Hope this helps.
Best,
Tsvetelin
I did that now and it worked successfully, thank you SO much !
Hi Mohamed!
You are very welcome!
Best,
The 365 Team