i have one query
@recommendations = Recommendation.select(‘cnames.name,max(recommendations.count)’).
where(‘recommendations.skill= ?’,@key).
order(‘recommendations.company_id ASC’).
group(‘recommendations.company_id’).
joins(‘JOIN recommendations ON cnames.id = recommendations.company_id’)
when i run this query i got this error
PG::Error: ERROR: table name “recommendations” specified more than once
Why it shows like that?