Re: sql join query

From: Eric Lease Morgan <emorgan_at_nyob> Date: Fri, 29 Oct 2021 10:02:04 -0400 To: CODE4LIB_at_LISTS.CLIR.ORG

On Oct 29, 2021, at 9:54 AM, Mike Rylander <mrylander_at_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

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.