摘要： select PerInfo.*,RGD.*,DV.* from (select * from dbo.G_PersionInfo g where 1=1 and GpsID<>'' )PerInfoleft join (select d.* from dbo.Device d where not exists( select 1 from dbo.Device where GpsID... 阅读全文