[MySQL] JOIN, dove sbaglio?

[tv9vision]

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

[piero.mac]

Se assegni degli ALIAS alle tabelle poi devi usare quelli, a prescindere da altri errori.

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

[tv9vision]

Grazie mille, funziona!