Tell me the vehicle id and staff id for all lesson id's...
SELECT T1.vehicle_id ,  T2.staff_id FROM Vehicles AS T1 JOIN Lessons AS T2 ON T1.vehicle_id   =   T2.vehicle_id
vehicle id and staff id for all lesson id's requires joining the Vehicles table with the Lessons table on vehicle_id;