Error! - browse2test -- SELECT carmakes.name, kn_parts.model FROM carmakes 

LEFT JOIN kn_parts on kn_parts.modelID = '' 

WHERE ID = '' ORDER BY name