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 = T2.ID_EW_CLIENTI

SET

T1.ID_ADRESSE = T2.IDCLIENTI

WHERE

T1.ID_EW_CONTACT <> 0

AND

T2.CODE LIKE ‘FPAR02’

Encore un exemple :

UPDATE
FA4_MECA_DROIT
join MECA on FA4_MECA_DROIT.M0CLEUNIK = MECA.M0CLEUNIK
SET
FA4_MECA_DROIT.INT_MODIFIER = 0
WHERE

FA4_MECA_DROIT.ID_MODULE IN (‘ARTICLE’) and
MECA.NOM NOT IN (‘BRUA’, ‘MAS INFORMATIQUE »QUADRELLI’,’BEYER’,’GUEDEU’)