图解SQL的inner join、left join、right join、full outer join、union、union all的区别

https://www.cnblogs.com/logon/p/3748020.html

select 1, 2, 3, area_id, 4, 5, 6 from t_main_work mv inner join t_work w on mv_target=w.id inner join t_area a on a.id=w.area_id

posted on 2018-10-23 01:54  粤B_Liao  阅读(244)  评论(0编辑  收藏  举报

导航