SQL UPDATE AVEC JOINTURE
update [dbo].[PRODUITS] set [PRODELAI] = DELAILIVPREV FROM [dbo].[PRODUITS] AS PR INNER JOIN [dbo].[TIERS_FP] AS FP ON FP.TIRID = PR.TIRID Autre exemple : UPDATE FA4_TIERS_CONTACT T1 JOIN CLIENTI T2 ON T1.ID_EW_CONTACT…
update [dbo].[PRODUITS] set [PRODELAI] = DELAILIVPREV FROM [dbo].[PRODUITS] AS PR INNER JOIN [dbo].[TIERS_FP] AS FP ON FP.TIRID = PR.TIRID Autre exemple : UPDATE FA4_TIERS_CONTACT T1 JOIN CLIENTI T2 ON T1.ID_EW_CONTACT…