--倆表應該是用vid關聯吧。--trySelect * From I_Position
Where ID Not In
(Select A.ID From I_Position A Inner Join C_CoreComparison B
On A.vid = B.vid
Where (A.gps_time Between B.stop_time And B.start_time)
And (A.latitude Between B.stop_latitude And B.start_latitude)
And (A.latitude Between B.stop_longtitude And B.start_longtitude))
Where ID Not In
(Select A.ID From I_Position A Inner Join C_CoreComparison B
On A.vid = B.vid
Where (A.gps_time Between B.stop_time And B.start_time)
And (A.latitude Between B.stop_latitude And B.start_latitude)
And (A.latitude Between B.stop_longtitude And B.start_longtitude))
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货