Saturday, 5 September 2015

SQL Update Query to Update a Table by Mapping with another Table

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];


No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts