SQL Server: Replicate data from multiple tables into one

Is it possible to replicate data from multiple tables into one real time? For example I have 3 tables: Table: DriverLocation Columns: DriverId, Latitude, Longtide, GpsLastUpdate, Speed, … Table: Driver Columns: DriverId, FirstName, LastName, Address, IsActive, … Table: Job Columns: JobId, DriverId, JobName, Pickup, Delivery, … I’d like to create a join query between these…

Details