How to Do Mapping a Table with another Table with SQL Update Query
Suppose , we have a Table called 'Forecast_Table' , in which a column called 'Bus Entity' is need to update by Mapping it with a another Table called 'Map_Table' , then we can do it by using the Update query with Inner Join clause.
UPDATE Forecast_Table INNER JOIN Map_Table
ON [Forecast_Table ].Tech=Map_Funnel.Tech
SET Forecast_Table.[Bus Entity] = Map_Table.[Bus Entity];