mysql 运行 语句
drop view if exists xiangqing;create view xiangqing(UserName,TrueName,MemberIDPrizeFee,AgentID,Mobile) as select v.UserName,v.TrueName ,v.MemberID,v.PrizeFee,v.AgentID,v.Mobile from(select t.UserName,t.TrueName ,t.MemberID,t.PrizeFee,t.AgentID,a.Mobile from(select c.UserName,c.TrueName,c.MemberID,b.PrizeFee,c.AgentID from Member as c left join MemberFee as b on c.MemberID=b.MemberID) as t left join MemberDetail as a on t.MemberID=a.MemberID) as v;
mysql #1349 - ......
阅读全文