Join but only return one instance

[scotchegg78]

Hi guys

 

I hav a company table and an image table.

Image table has (id,companyid,ext) so you can of course have duplicate companyids if the code has allowed it. But i want to join on company and only get one if there are more!

 

I do not get the image.companyid so can not make this distinct in the select, so how can i join so i only get one instance?

 

at the moment the join is ...

 

LEFT JOIN image on image.recruiterfk=company.id

 

group by ??

 

thanks

 

[fenway]

First you need to decide how you want to aggregate the company_ids.