Advertisement
Aleksiev

SoftUni Databases Exam - 18

Mar 1st, 2015
306
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.30 KB | None | 0 0
  1. SELECT tc.name AS `traning center`,
  2.     DATE_FORMAT(t.start_date, '%Y-%m-%d') AS `start date`,
  3.     c.name AS `course name`,
  4.     c.description AS `more info`
  5. FROM timetable AS t
  6. JOIN training_centers AS tc ON tc.id = t.training_center_id
  7. JOIN courses AS c ON c.id = t.course_id
  8. ORDER BY t.start_date, t.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement