27,579
社区成员
发帖
与我相关
我的任务
分享
create view xxxx
as
select a.*,b.quantity,c.xx,c.yy,c.zz
from a inner join (select * from b where [type]=1) b on a.id=b.id inner join c on a.id=c.id
where c.xx>100
create view vie_test
as
select a.*,b.Quantity,b.type,xx,yy,zz
from a
left join b on a.id=b.id and b.type=1
left join c on a.id=c.id
where c.xx>100
create view vie_test
as
select a.name,a.size,b.Quantity,xx,yy,zz
from a
left join b on a.id=b.id
left join c on a.id=c.id
where c.xx>100