window.ENTITIES={'/api/snippets/sql/mysql%20full%20outer%20join':[{"result":true,"message":null,"batch":{"type":"sql","name":"mysql full outer join","items":[{"id":"Dnn37D","type":"sql","name":"MySQL FULL OUTER JOIN","content":"SELECT * FROM table_a A\nLEFT JOIN table_b B ON A.key = B.key\nUNION\nSELECT * FROM table_a A\nRIGHT JOIN table_b B ON A.key = B.key","source":"https://dirask.com/posts/MySQL-JOIN-query-cases-with-examples-10rb8p","author":{"id":"MoydPa","name":"Chronal","avatar":"1629030395794__MoydPa__w40px_h40px.png","points":697,"role":"BASIC"},"creationTime":1635170322000,"updateTime":null,"removalTime":null},{"id":"1eP8Gj","type":"sql","name":"MySQL Full Outer Join","content":"SELECT * \nFROM `users` \nLEFT JOIN `departments` ON `departments`.`id` = `users`.`department_id`\nUNION\nSELECT * \nFROM `users` \nRIGHT JOIN `departments` ON `departments`.`id` = `users`.`department_id`","source":"https://dirask.com/posts/MySQL-Full-Outer-Join-p5NlRj","author":{"id":"VDr21D","name":"Wade","avatar":"1629129966526__VDr21D__w40px_h40px.jpg","points":562,"role":"BASIC"},"creationTime":1635173580000,"updateTime":null,"removalTime":null},{"id":"prg7bj","type":"sql","name":"MySQL Full Outer Join","content":"SELECT * FROM `table1`\nLEFT JOIN `table2` ON `table2`.`column_name` = `table1`.`column_name`\nUNION\nSELECT * FROM `table2`\nRIGHT JOIN `table2` ON `table2`.`column_name` = `table1`.`column_name`;","source":"https://dirask.com/posts/MySQL-Full-Outer-Join-p5NlRj","author":{"id":"EagXqo","name":"Laylah-Walsh","avatar":"1629141325515__EagXqo__w40px_h40px.jpg","points":654,"role":"BASIC"},"creationTime":1635173582000,"updateTime":null,"removalTime":null}]}}]};