Update Table 1 Certain Fields based on Table 2

Hello experts,



I would like to achieve the following task described below:

Just for an example i have two tables = Table1 and Table2



Table1 contains following fields: ID , CusName, Price , Date_

Table2 Contains following fields: ID, CusName, Price, Date_



I would like to update Price and Date Field of Table1 where Table1 ID matching with Table2 and Table2 Date is maximum(most recent date).



Hope this explanation is clear understandable.



Waiting of your response.



Rehan

Update Table 1 Certain Fields based on Table 2