Last answered:

07 Jul 2023

Posted on:

03 Jul 2023

0

Resolved: Why don't aliases work?

3 answers ( 2 marked as helpful)
Instructor
Posted on:

03 Jul 2023

0

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

Posted on:

05 Jul 2023

0

I did that now and it worked successfully, thank you SO much !

Instructor
Posted on:

07 Jul 2023

0

Hi Mohamed!
You are very welcome!
Best,
The 365 Team

Submit an answer