 |
 |
Howdy Eric, My SQL is awful, but my first thought was a DISTINCT inside the GROUP_CONCAT. A quick google turned this up: https://stackoverflow.com/questions/3083499/mysql-distinct-on-a-group-concat Maybe it gets you closer? Yours, Kevin On 10/29/21 10:02, Eric Lease Morgan wrote: > On Oct 29, 2021, at 9:54 AM, Mike Rylander <[log in to unmask]> wrote: > >> SELECT b.identifier, >> GROUP_CONCAT( e.entity, '; ' ) AS entities, >> GROUP_CONCAT( k.keyword, '; ' ) AS keywords >> FROM bibliographics AS b >> LEFT JOIN entities AS e ON e.identifier = b.identifier >> LEFT JOIN keywords AS k ON k.identifier = b.identifier >> GROUP BY b.identifier > H > Thank you for the prompt reply. I tried that, but I get the same sort of output: > > identifier = american-authors > entities = bible; clemens; emerson; emerson; howells; irving; little women; mark twain; mark twain's; new york; poe; the innocents abroad; uncle tom's cabin > keywords = york; york; york; york; york; york; york; york; york; york; york; york; york > > -- > Eric M. >