CrashTest.cmd

use server;

SET character_set_results=utf8;

SELECT towns.name, dest.name, time.name, date, seats, driver.name 
FROM qdriver 
INNER JOIN direction ON direction.id = id_direction 
INNER JOIN towns ON towns.id = direction.id_source 
INNER JOIN towns as dest ON dest.id = direction.id_destination 
INNER JOIN driver ON driver.id = id_driver
INNER JOIN time ON time.id = id_time
ORDER BY date;

SELECT towns.name, dest.name, time.name, date, booked, passenger.name 
FROM qpassenger 
INNER JOIN direction ON direction.id = id_direction 
INNER JOIN towns ON towns.id = direction.id_source 
INNER JOIN towns as dest ON dest.id = direction.id_destination 
INNER JOIN passenger ON passenger.id = id_passenger
INNER JOIN time ON time.id = id_time
ORDER BY date;