#获取会员的上二级 drop view if exists vwMemberL2Parent; create view vwMemberL2Parent as select m.id, m.parent_
#获取会员的上二级
drop view if exists vwMemberL2Parent;
create view vwMemberL2Parent
as
select m.id,
m.parent_id,
m.nickname,
m.realname,
m.avatar,
m.mobile,
m.invite_merch_id,
L2.nickname as L2nickname,
L2.realname as L2realname,
L2.avatar as L2avatar,
L2.mobile as L2mobile
from `ims_tycb_xyl_member` as m
LEFT JOIN `ims_tycb_xyl_member` as L1 on m.parent_id = L1.id
LEFT JOIN `ims_tycb_xyl_member` as L2 on L1.parent_id = L2.id
--结束END--
本文标题: mysql之上二级
本文链接: https://www.lsjlt.com/news/6186.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0