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 <mrylan...@gmail.com> 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.
