62,046
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM sys_CheckData
WHERE (ID >=
(SELECT TOP 1 sys_CheckData.ID
FROM sys_CheckData INNER JOIN
sys_CheckOneKm ON
sys_CheckOneKm.ID = sys_CheckData.COKid
WHERE (sys_CheckOneKm.CheckID = 117) and sys_CheckOneKm.Is_IRI=0 AND
(sys_CheckData.BeginPeg = 'K000+000'))) AND (ID <=
(SELECT TOP 1 sys_CheckData.ID
FROM sys_CheckData INNER JOIN
sys_CheckOneKm ON
sys_CheckOneKm.ID = sys_CheckData.COKid
WHERE (sys_CheckOneKm.CheckID = 117) and sys_CheckOneKm.Is_IRI=0 AND
(sys_CheckData.BeginPeg = 'K002+000')))