本帖最后由 戈少武 于 2024-8-1 16:37 编辑
(CASE WHEN 1 = 0 THEN a4.[mc] ELSE NULL END) as C4
在页面上用一个字段关联到另外一个表的另外一个字段,总关联不上,今天查了日志,发现生成的sql语句里面,自动增加了一个case when 语句。而我在设置关联时,并没有设置条件,不知道这个东西是怎么上去的,能帮忙分析一下吗?select a2.[xmjc] as C0,a1.[MC] as C1,a1.[spzt] as C2,
(CASE WHEN 1 = 0 THEN a3.[mc] ELSE NULL END) as C3,
(CASE WHEN 1 = 0 THEN a4.[mc] ELSE NULL END) as C4,
a5.[mc] as C5,a6.[mc] as C6,a7.[MC] as C7,a1.[HSJE] as C8,a1.[FKBL] as C9,
a.[LJJS] as C10,a.[HTYFK] as C11,a.[LJFK] as C12,a.[KFK] as C13,a.[LJKP] as C14,
a.[QKRQ] as C15,a.[JE] as C16,a.[FJ] as C17,a.[BZ] as C18,
a.[FGC_Rowversion] as C19,a.[ID] as C20
from [dbo].[HTFK] as a left join [dbo].[HTml] as a1 on a.[HTID] = a1.[ID]
left join [dbo].[XMK] as a2 on a1.[XMID] = a2.[ID]
left join [dbo].[ksk] as a3 on a1.[cgfbm] = a3.[bm]
left join [dbo].[ksk] as a4 on a1.[xsfbm] = a4.[bm]
left join [dbo].[ksk] as a5 on a1.[wfbm] = a5.[bm]
left join [dbo].[ksk] as a6 on a1.[dfbm] = a6.[bm]
left join [dbo].[zw_FzKmMx] as a7 on a1.[htfl] = a7.[qbh]
Where a.[ID] = 5288 这是生成的查询语句,别的地方都没有case when ,就上面那个C3,C4自动生成了。
|
|