[RESOLVED] Help on Update table

[GaryMazzone]

Using SQL Server 2005

I have a select statement that finds the data I need

Select * from histmasteruser HMU Inner Join meetingbroker.dbo.masteruser MU On Mu.MasterUserID = HMU.MasterUserId and MU.LastModifiedDate < HMU.LastModifiedDate]

I There a way I can use that in an Update Statement to Update the table Marked MU with the data in specified fields from the table marked HMU?

UPDATE TABLE statement?