Ciao,
ho questa query JOIN che mi da errore, dove sbaglio?

SELECT jos__rentcar_autos.*, jos__rentcar_companies.name, jos__rentcar_companies.id AS idcompany FROM jos__rentcar_autos AS cd LEFT JOIN jos__rentcar_companies AS cc ON cd.company_id = cc.id
Grazie