Cacher is the code snippet organizer for pro developers

create view v_requests
as
select
Request.*,
Vehicle.PlateNo
from Request(Nolock)
inner Join Vehicle(Nolock) on Vehicle.VehicleId=Request.VehicleId