how i count repetitious values join list collect any value's name?
i have twin tables, contains volunteers, contains venues. volunteers indifferent venue each.
the id venues list (venues.id) placed within volunteers list venue_id buttress (volunteers.venue_id).
i know i count relating values volunteers.venue_id buttress by
select venue_id, count(*) volunteers organisation venue_id
why i wish this: user volunteers indifferent any venue.
table: volunteers -- columns: id, name, venue_id
table: venues -- columns: id, venue_name
volunteers.venue_id = venues.id
i know join matter arrange count any venue, following review adult volunteers.venue_id venues.id imitation out venues.venue_name along count.
how i fasten twin tables imitation out venue name unbroken it, list count any invitation venue_id?
Comments
Post a Comment