select `train_station`.*, `train_type`.* from `train_station` left join `train_type` on `train_type`.`train_type_id` = `train_station`.`train_type_id`