SQL Answers Exercise 10-9

Exercise 10.9

Display a list of courses against departments ordered by the department name

SELECT course.title as coursetitle, department.name as departmentname
FROM course INNER JOIN department ON
course.departmentid = department.departmentid ORDER BY department.name

Top
RSS
Facebook
Facebook
Google+
Google+
https://www.paulvgibbs.com/learn-php-and-mysql-web-programming/code-samples/chapter-10/sql-answers-exercise-10-9