How to use group by in magento collection with join query?

jigar_karangiya

jigar_karangiya

You need to add table name in group by condition.As you did not added on conditions table name at table group('entity_id') so query did not find columns name

getSelect()->group('e.entity_id');

Logic is:

$collection->getSelect()->group('TABLE_NAME.FIELD_NAME')