Breaking News: Grepper is joining You.com. Read the official announcement!

how to join tables with many to many relationships

Condemned Civet answered on May 4, 2020 Popularity 9/10 Helpfulness 2/10

answer how to join tables with many to many relationships

how to join tables with many to many relationships

Comment

SELECT 
    p.person_id, 
    p.name, 
    a.conference, 
    b.publication
FROM
    person AS p
    LEFT JOIN (SELECT
                   pc.person_id,
                   c.conference
               FROM
                   person_conference AS pc
                   INNER JOIN conference AS c 
                     ON pc.conference_id = c.conference_id) AS a
      ON p.person_id = a.person_id 
    LEFT JOIN (SELECT
                   pp.person_id,
                   ppp.publication
               FROM
                   person_publication AS pp
                   INNER JOIN publication AS ppp 
                     ON pp.publication_id = ppp.publication_id) AS b
      ON p.person_id = b.person_id

Popularity 9/10 Helpfulness 2/10 Language whatever

Source: dba.stackexchange.com

Tags: join many-to-many relationships whatever

Link to this answer
Share Copy Link