Advertisement
dim4o

Problem 18. MySQL Database and Query

Jul 12th, 2015
274
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.27 KB | None | 0 0
  1. SELECT
  2.     tc.Name AS 'traning center',
  3.     t.start_date AS 'start date',
  4.     c.Name AS 'course name',
  5.     c.description AS 'more info'
  6. FROM training_centers tc
  7.     JOIN timetable t
  8.         ON tc.id = t.training_center_id
  9.     JOIN courses c
  10.         ON t.course_id = c.id
  11. ORDER BY t.start_date, t.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement