请教一个SQL查询中where子句的问题!!!
请教一个SQL查询中where子句的问题!!!
视图代码如下:
CREATE VIEW dbo.v_store_bj
AS
select top 100 percent a.M_id,a.m_cplb,SUM(isnull(a.sl,0)) as total,a.m_min,a.m_max
FROM ( SELECT a.m_id,
a.ck_id,
a.sl,
b.m_cplb,
b.m_min,
b.m_max
FROM store_ck a,E1_material b
WHERE a.m_id = b.m_id) a
where a.total>=a.m_max or a.total<=a.m_min
GROUP BY a.M_id,a.m_cplb,a.m_min,a.m_max
ORDER BY a.m_cplb DESC
其中的where子句中的a.tatal会报错,请问各位我想用SUM(isnull(a.sl,0))与a.m_max比较进行条件判断,如何纠正该where子句???
请各位帮助!!多谢