select
  Employees.*,
  Departments.department,
  Cars.*
from Employee
join department on departments.id = employees.department_id
join Cars on cars.emp_id = employees.id order by employees.id