22,209
社区成员
发帖
与我相关
我的任务
分享
select V.V_No,S.Typetxt,D.Deviceid from
(select DeviceID from DynData where Time>@StartTime and
Time<@EndTime and Longitude<@MaxX and Longitude> @MinX
and latitude<@MaxY and latitude>@MinY GROUP BY DeviceID) D inner join Vehicle V On D.DeviceID=V.V_DeviceID
inner join SysType S on V.V_TeamNo=S.TypeID where s.fieldname='V_teamNo'
select V.V_No,S.Typetxt,D.Deviceid from
(select distinct DeviceID from DynData where Time>@StartTime and
Time<@EndTime and Longitude<@MaxX and Longitude> @MinX
and latitude<@MaxY and latitude>@MinY) D inner join Vehicle V On D.DeviceID=V.V_DeviceID
inner join SysType S on V.V_TeamNo=S.TypeID where s.fieldname='V_teamNo'
--try
select distinct V.V_No,S.Typetxt,D.Deviceid from DynData d
inner join Vehicle V On D.DeviceID=V.V_DeviceID
and d.Time>@StartTime and
d.Time<@EndTime and d.Longitude<@MaxX and d.Longitude> @MinX
and d.latitude<@MaxY and d.latitude>@MinY
inner join SysType S on V.V_TeamNo=S.TypeID where s.fieldname='V_teamNo'