mysql - 如何在mysql中加入2个 View ？

This question already has answers here:

How to do a FULL OUTER JOIN in MySQL?
                                
                                    （14个回答）
                                
                        
                                2年前关闭。
            
                    
我有2个带有列的视图，

view1 = (ID, Number)
view2 = (ID, Number, Name)

如何创建选择显示以使

Display = (ID, Number, Name)

而Display是FULL OUTER JOIN view1和view2。

最佳答案

SELECT view2.*
FROM   view1
       LEFT JOIN view 2
           ON view1.id = view2.id
UNION

SELECT view2.*
FROM   view1
       RIGHT JOIN view 2
           ON view1.id = view2.id