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