Resolved: Why don't aliases work?
3 answers ( 2 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
Submit an answer
![](https://365datascience.com/resources/assets/images/ds-fp2024-banner-side.webp)