 |
 |
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 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.