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

LEFT JOIN kn_parts on kn_parts.modelID = '565' 

WHERE ID = 'TALBOT' ORDER BY name