22,209
社区成员
发帖
与我相关
我的任务
分享
Select TB_ICKaBiao.ID,TB_ICKaBiao.ICKaHao,TB_ICKaBiao.ICKaLeiXing,TB_ICKaBiao.ICKaZhiKaRiQi,
ICKaZhuangTai,TB_ICKaBiao.Remark ,dbo.TB_SheDingShuJuBiao.Shedingshuju as ickl,TB_SheDingShuJuBiao.Shedingshuju as zhuangt
From TB_ICKaBiao,TB_SheDingShuJuBiao
Where TB_ICKaBiao.ICKaLeiXing=TB_SheDingShuJuBiao.ID or TB_ICKaBiao.ICKaZhuangTai=TB_SheDingShuJuBiao.ID
SELECT
a.ID ,
a.ICKaHao ,
a.ICKaLeiXing ,
a.ICKaZhiKaRiQi ,
a.ICKaZhuangTai ,
a.Remark ,
b.Shedingshuju AS ickl ,
b.Shedingshuju AS zhuangt
FROM TB_ICKaBiao a
CROSS APPLY
(
SELECT TOP(1) * FROM TB_SheDingShuJuBiao m
WHERE m.ID = a.ICKaLeiXing OR m.ID = a.ICKaZhuangTai
ORDER BY (CASE WHEN m.ID = a.ICKaLeiXing THEN 0 ELSE 1 END)
) b