hallo, I would like to convert this request from JET SQL into T sql
UPDATE [Import] INNER JOIN [Dat_XRate]
ON ([Import].[Mois] = [Dat_XRate].[Mois]
AND [Import].[annee] = [Dat_XRate].[annee]
AND [Dat_XRate].[CurS] = 'XOF'
AND [Dat_XRate].[CurD] = 'USD')
SET [Valusd] = ((([Valeur] / [Rate] + 0.5) * 100) \1) /100
It is very simple but each time I want to use a "INNER JOIN"...