Resolved: Why don't aliases work?

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 !