SQL : SELECT * FROM car_stock, car_models, car_body_types, car_fuel_types WHERE car_id = 506 AND car_stock.car_model_id = car_models.model_id AND car_stock.body_type_id = car_body_types.body_type_id AND car_stock.fuel_type_id = car_fuel_types.fuel_id