mysql - SQL,how to select attributes from different tables? -

mysql - SQL,how to select attributes from different tables? -

i want select user_name,vehicle_name , maintain_cost 3 different tables user_id,vehicle_id , maintain_cost_id equal three,so query used,i seek this

(select user_name,vehicle_name,maintain_cost user,vehicle,maintain_cost user_id='3')

but not know how set vehicle_id='3' , maintain_cost_id='3'

use left join, illustration can found here: http://www.w3schools.com/sql/sql_join_left.asp

mysql sql join