MySQL – FULL OUTER JOIN nadomjestak

Problem:

Trebamo spojiti podatke iz dvije tablice na način da dobijemo sve podatke iz obje tablice s time da se podaci koji se poklapaju ne ponavljaju nego joinaju.

Tu bi poslužio nekakav FULL OUTER JOIN.

Kad bi ga bilo.

S obzirom da ga nema:

Rješenje:


SELECT * FROM tbl_a
LEFT JOIN tbl_b ON tbl_a.id = tbl_b.id
UNION
SELECT * FROM tbl_a
RIGHT JOIN tbl_b ON tbl_a.id = tbl_b.id
This entry was posted on Wednesday, April 29th, 2015 at 1:28 pmand is filed under MYSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.