LINQ怎么写，求高手指教！
本帖最后由 q107770540 于 2013-12-10 21:16:50 编辑
select d.Plate,b.TerminalSign,b.[Longitude],b.[Latitude],b.[speed],b.[direction],b.[FullOrEmpty],b.[AccStyle],b.[GpsTime],e.Name
from [TaxiRadarHistory].[dbo].TaxiRdHistorydata_20131210 as b
right join (select [TerminalSign],max(GpsTime) as GpsTime from [TaxiRadarHistory].[dbo].TaxiRdHistorydata_20131210 where GpsTime>dateadd(mi,-600,getdate()) group by TerminalSign) as a
on b.TerminalSign=a.TerminalSign and b.GpsTime=a.GpsTime
left join TR_Device as c on a.TerminalSign=c.DeviceNum
left join TR_Car d on c.DeviceID=d.Phone and d.IsScrapped=0
left join TaxiRdDriverLogin e on b.TerminalSign=e.TerminalSN
where e.LoginOut is null and e.LoginIn<b.GpsTime and b.TerminalSign='0867493010086303'
