sql 语句一:
alter view tv_dw as --测试
select menuNO,sum(Quantity) as AA
from tb_RecordDetails where orderNo like 'a003081118%'
group by menuNo
sql 语句二:
select a.departmentNo,isnull(c.bigkind,'') as bigkind,
isnull(e.smkind,'') as Smkind,sum(a.counts * b.AA ) as AA,a.Unit
from tb_foodfactoryCF a
left join tv_dw b on a.MenuNo= b.MenuNO
left join tb_bigkind c on a.bingkindNo=c.binkindNO
left join tb_smkind e on a.smkind = e.smkindNO
where a.departmentNo ='a003' and AA is not null and bigkind like '%肉%'
group by a.DepartmentNo,c.Bigkind,e.smkind,a.Unit我的sql 语句一是创建一个试图,为了方便给sql 语句二 来访问。
能不能把sql 语句一 和sql 语句二 合并成一条 sql 语句?
alter view tv_dw as --测试
select menuNO,sum(Quantity) as AA
from tb_RecordDetails where orderNo like 'a003081118%'
group by menuNo
sql 语句二:
select a.departmentNo,isnull(c.bigkind,'') as bigkind,
isnull(e.smkind,'') as Smkind,sum(a.counts * b.AA ) as AA,a.Unit
from tb_foodfactoryCF a
left join tv_dw b on a.MenuNo= b.MenuNO
left join tb_bigkind c on a.bingkindNo=c.binkindNO
left join tb_smkind e on a.smkind = e.smkindNO
where a.departmentNo ='a003' and AA is not null and bigkind like '%肉%'
group by a.DepartmentNo,c.Bigkind,e.smkind,a.Unit我的sql 语句一是创建一个试图,为了方便给sql 语句二 来访问。
能不能把sql 语句一 和sql 语句二 合并成一条 sql 语句?
isnull(e.smkind,'') as Smkind,sum(a.counts * b.AA ) as AA,a.Unit
from tb_foodfactoryCF a
left join (select menuNO,sum(Quantity) as AA
from tb_RecordDetails where orderNo like 'a003081118%'
group by menuNo
) b on a.MenuNo= b.MenuNO
left join tb_bigkind c on a.bingkindNo=c.binkindNO
left join tb_smkind e on a.smkind = e.smkindNO
where a.departmentNo ='a003' and AA is not null and bigkind like '%肉%'
group by a.DepartmentNo,c.Bigkind,e.smkind,a.Unit
同意xudajian的做法
select a.* from tb
left join ( --你的视图) b
on a.code=b.code
--.....