Question

Hey, so this is a question i got in my database class. we are supposed to use mysql for this. I have been working on it for about an 45 minutes now but just cant seem to get it right. Any and all help is greatly appreciated.

Write a query to display the employee’s last name, the territory’s territory description, and the region’s region description for each employee in the employee table. Sort the results by the employee’s last name.

Tables - Employees, territorydescription, regiondescription

Columns - lastname, territorydetails, region details, territoryid, regionid,

Answer 1

Answer:

Select e.lastname,td.territorydetails,rd.regiondetails,rd.territoryid,rd.regionid from Employees e
join territorydescription td on td.EmployeeID=e.EmployeeID
join regiondescription rd on rd.territoryid = td.territoryid
order by e.lastname.

Employee table will be linked with territorydescription table. I assumed Employee will be the foreign key.

Let me know in case if you have any questions. Thanks and all the best.