SELECT A.id,A.fydate as 计费日期,A.tdbh as 提单编号,A.cbje as 成本,(CASE A.id  WHEN '2' THEN A.cbje ELSE 0 END) AS 差价金额  FROM ckd  A

case when then 怎么替代？

SELECT A.id,A.fydate as 计费日期,A.tdbh as 提单编号,A.cbje as 成本 from ckd A
可以执行，加了 case...when..then...则出错了。（在sql数据库可以执行）

没错 就用 IIF!

不过这就出错了：
select A.id,A.fydate,A.cbje,(iif(c.dm='CJ',A.cbje,0)) as cb from ckd A,(select id,dm from lsz1) C where A.id=C.id

分开执行没错，难道不能对  A 和 C操作？