I have a query which works on the select but I dont know how to create the update so thattw.marque in tblwords in db dictionary get updated to tcwa.sCWDescGroup from the clientdata db
--UPDATE [dictionary].[dbo].[TblWords]--SET tw.Marque=tcwa.sCWDescGroupSELECT tw.ClientCode, tab2.[MVRIS CODE], tab2.MARQUE, tcwa.sCWDesc, tcwa.sCWDescGroup, tcwa.sCWTechnicalGroupFROM [dictionary].[dbo].[TblWords] tw INNER JOIN [clientdata].[dbo].[smmt] tab2 ON tw.ClientCode = tab2.[MVRIS CODE] inner JOIN ClientData.[dbo].[tCWAlias] tcwa ON tab2.MARQUE=tcwa.sCWDesc WHERE tcwa.sCWTechnicalGroup='name' group BY tw.ClientCode, tab2.[MVRIS CODE], tab2.MARQUE, tcwa.sCWDesc, tcwa.sCWDescGroup, tcwa.sCWTechnicalGroup