SELECT top 1 a.simNum,a.UserID,b.DeviceNum,c.DeviceVersion FROM VehicleInfo a JOIN VehicleDetailInfo b
ON b.VehID=1028 join DeviceModelInfo c ON b.DeviceNo=c.DeviceNo
转载于:https://www.cnblogs.com/kaixin110/archive/2007/12/29/1019565.html
转载于:https://www.cnblogs.com/kaixin110/archive/2007/12/29/1019565.html