how to join tables with many to many relationships
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
Are there any code examples left?
New code examples in category Other
-
Other 2023-03-27 22:50:10 how to select the whole line in vscode with keyboard shortcut
-
Other 2022-03-27 22:45:24 income of a web developer
-
Other 2022-03-27 22:35:01 \pyrcc_main.py: File does not exist 'resources.qrc'
-
Other 2022-03-27 22:30:45 rick roll embed code
-
Other 2022-03-27 22:20:08 Circuit_04_Potentiometer
-
Other 2022-03-27 22:20:05 iterative power
-
Other 2022-03-27 22:15:11 flutter run all
-
Other 2022-03-27 22:10:05 when is karlson release
-
Other 2022-03-27 22:10:02 wp .htaccess example
-
Other 2022-03-27 22:00:08 bash pause in file read line by line