Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT tc.name AS `traning center`,
- DATE_FORMAT(t.start_date, '%Y-%m-%d') AS `start date`,
- c.name AS `course name`,
- c.description AS `more info`
- FROM timetable AS t
- JOIN training_centers AS tc ON tc.id = t.training_center_id
- JOIN courses AS c ON c.id = t.course_id
- ORDER BY t.start_date, t.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement