SQL语句执行顺序问题
执行下面的语句报类型转换错误，错误之处已用红色标记。以下错误
SQL code:
SELECT M.KPIID from TB_KPIS AS M
WHERE M.KPIID IN
(
SELECT A.KPIID from TB_KPIS AS A WHERE A.KPIFrequencyType=4--按天
UNION
SELECT B.KPIID from TB_KPIS AS B WHERE B.KPIFrequencyType=1 AND datediff(day,[color=#FF0000]Convert(datetime,B.KPIFrequencyValue),[/color]getdate())=0--按年
UNION
SELECT C.KPIID from TB_KPIS AS C WHERE C.KPIFrequencyType=2 AND Convert(INT,C.KPIFrequencyValue)=day(getdate())--按月
UNION
SELECT D.KPIID from TB_KPIS AS D WHERE D.KPIFrequencyType=3 AND charindex(convert(varchar(10),datepart(weekday,getdate())),D.KPIFrequencyValue)!=0
)
但是如果我只执行其中的子句，则完全正确。以下正确
SQL code:
SELECT A.KPIID from TB_KPIS AS A WHERE A.KPIFrequencyType=4--按天
UNION
SELECT B.KPIID from TB_KPIS AS B WHERE B.KPIFrequencyType=1 AND datediff(day,[color=#FF0000]Convert(datetime,B.KPIFrequencyValue),[/color]getdate())=0--按年
UNION
SELECT C.KPIID from TB_KPIS AS C WHERE C.KPIFrequencyType=2 AND Convert(INT,C.KPIFrequencyValue)=day(getdate())--按月
UNION
SELECT D.KPIID from TB_KPIS AS D WHERE D.KPIFrequencyType=3 A
相关问答：
我有多个表A B C 结构是一样的，都有2个字段name和content,我要搜索所以表所有字段中包含“中国”的内容 这个SQL语句怎么写
如何将多个表的查询结果连成一个表 这个SQL语句怎么写 表的结构是一样的
例如� ......
clientserial devseral chunnelnum devdata5
CZ0001 308001 5000 11.1
CZ0001 308001 5001 11.2
CZ0001 308001 5002 11.3
CZ0001 3080 ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
姓名</td>
......
可能因为工作的原因 接触数据库这块比较少，之前都是做程序这块，数据库这块都有专门的人来做 分工都很明细 所以对数据库这一块完全不了解。前段时间 去面试了几家公司 几乎都是在数据库这块挂掉的 连个简单的SQ ......
