SELECT vm.RegistrationNo,
OilChangeOdometer,
OilChangeDate,
ServicingOdometer,
ServicingChangeDate,
TyreChangeOdometer,
TyreChangeDate,
driverid,
drivername,
licenseexpiry,
contact,
vh.Insurancestartdate,
vh.insuranceexpirydate,
vh.insurancecompany
FROM VehicleMaintance AS vm
FULL OUTER JOIN
vehicle_master AS vh
ON vm.RegistrationNo = vh.RegistrationNo
WHERE vm.RegistrationNo = @vehId
AND ((OilChangeDate BETWEEN @strFromDt AND @strToDt)
OR (ServicingChangeDate BETWEEN @strFromDt AND @strToDt)
OR (TyreChangeDate BETWEEN @strFromDt AND @strToDt));
选择时,我只需要只oilchangedateand部分时间的日期部分。亚姆在报告中显示,所以我只需要日期部分将不显示时间部分请在我的查询本身的编辑和显示。| ashok_89