SHARE
TWEET

SoftUni Databases Exam - 18

Aleksiev Mar 1st, 2015 220 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top