Select distinct a.Stcd,b.Stnm, a.ID,a.ParaKind,c.Re,a.ParaValue,a.CollectTime, iif(a.Imported=0,''否'',''是'') as Imported from (T_Data as a '
+ 'left join T_StationMarker as b on a.Stcd=b.Stcd) inner join T_ParaKind as c on ( a.CollectTime between #%s# and #%s# and c.ParaKind=a.ParaKind ) order by a.CollectTime asc 数据表为sql2005中的表,表中字段imported的类型为int型,运行提示‘=’附近有错误,好像是第一行的等号 ,求解。
+ 'left join T_StationMarker as b on a.Stcd=b.Stcd) inner join T_ParaKind as c on ( a.CollectTime between #%s# and #%s# and c.ParaKind=a.ParaKind ) order by a.CollectTime asc 数据表为sql2005中的表,表中字段imported的类型为int型,运行提示‘=’附近有错误,好像是第一行的等号 ,求解。
iif(a.Imported=0,''否'',''是'') as Imported from (T_Data as a '
+ 'left join T_StationMarker as b on a.Stcd=b.Stcd)==>>case when a.Imported=0 then ''否'' else ''是'' end as Imported from ...
另外去掉红色的括号
(case when a.Imported=0 then ''否'' else ''是'' end) as Imported from