If we join two tables where two tables have some of the columns that have the same name, DeviceEvents | join tmpTable on Time here if both the tables have Time column, the result will contain columns ...