MySQL多表连接操作

1 select * from userinfo ,dapartment where userinfo.part_id = dapartment.id; 2 --左连接: 左边全部显示 3 select * from userinfo left join dapartment on userinfo.part_id=dapartment.id; 4 --右连接:右边...
posted @ 2018-12-23 20:45  塔塔尔族  阅读(188)  评论(0)  编辑  收藏  举报