Select  v_id as dyn_vehid,Dyn_Time ,v_companyid ,dyn_mile  
        From WisdomTaxiPosition_2015_1_15..T_Dyndata WITH (NOLOCK) 
left Join V_CompanyVehicle WITH (NOLOCK) On Dyn_VehID=V_Id 
        Where  dyn_mile is not null 
        and Dyn_Time Between '2015-01-15 00:00:00' And '2015-01-15 23:59:59' 
        And TenantId=123476 And V_CompanyID=1  

Union All 

Select  v_id as dyn_vehid,Dyn_Time ,v_companyid ,dyn_mile  
        From WisdomTaxiPosition_2015_1_16..T_Dyndata WITH (NOLOCK) 
left Join V_CompanyVehicle WITH (NOLOCK) On Dyn_VehID=V_Id 
       Where  dyn_mile is not null 
      and Dyn_Time Between '2015-01-16 00:00:00' 
      And '2015-01-16 17:20:11' 
      And TenantId=123476 And V_CompanyID=1 

select xxxxx  from(
Select  v_id as dyn_vehid,Dyn_Time ,v_companyid ,dyn_mile  
        From WisdomTaxiPosition_2015_1_15..T_Dyndata WITH (NOLOCK) 
left Join V_CompanyVehicle WITH (NOLOCK) On Dyn_VehID=V_Id 

Union All 

Select  v_id as dyn_vehid,Dyn_Time ,v_companyid ,dyn_mile  
        From WisdomTaxiPosition_2015_1_16..T_Dyndata WITH (NOLOCK) 
left Join V_CompanyVehicle WITH (NOLOCK) On Dyn_VehID=V_Id 


)
 temp 
where 条件