How to join 2 views in mysql? -


this question has answer here:

i have 2 views columns,

view1 = (id, number) view2 = (id, number, name) 

how create select display such that

display = (id, number, name) 

and display full outer join view1 , view2.

select view2.*   view1        left join view 2            on view1.id = view2.id union  select view2.*   view1        right join view 2            on view1.id = view2.id 

Comments

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

unity3d - Unity SceneManager.LoadScene quits application -

python - Error while using APScheduler: 'NoneType' object has no attribute 'now' -