sqlserver - 这句SQL有更简便或更优化的写法么？

问题描述

问 题

--有两张表[3d_Zf_Tzje]数据表、[3d_Zf_Tzje_Record]数据记录表

--[3d_Zf_Tzje_Record]的TzjeId关联[3d_Zf_Tzje]的Id

select  top 1 Id,Cid,Je,AddTime,AddId,AddContent from [3d_Zf_Tzje]  where Id in (select TzjeId from [3d_Zf_Tzje_Record] where State=0) and Cid=125

解决方案

SELECT
    A.Id,
    A.Cid,
    A.Je,
    A.AddTime,
    A.AddId,
    A.AddContent
FROM
    [3d_Zf_Tzje] A
INNER JOIN
    [3d_Zf_Tzje_Record] R
ON
    R.TzjeId = A.Id AND State = 0
WHERE
    A.Cid = 125
GROUP BY
    A.Id;

这篇关于sqlserver - 这句SQL有更简便或更优化的写法么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！