scotchegg78 Posted December 17, 2008 Share Posted December 17, 2008 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 Link to comment https://forums.phpfreaks.com/topic/137348-join-but-only-return-one-instance/ Share on other sites More sharing options...
fenway Posted December 17, 2008 Share Posted December 17, 2008 First you need to decide how you want to aggregate the company_ids. Link to comment https://forums.phpfreaks.com/topic/137348-join-but-only-return-one-instance/#findComment-718055 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.