how to write correctly this update ?

2019-05-22 Thread Pierre Couderc
I have tried many ways to update a table  : UPDATE  personnes T1 SET T1.nom_naiss=T1.nom FROM  personnes T2, personnes T3 WHERE  ; UPDATE  personnes T1 SET T1.nom_naiss=T1.nom FROM  personnes T1, personnes T2, personnes T3 WHERE ..; In my case , where clause is : WHERE T1.id=T2.id_mer

Re: how to write correctly this update ?

2019-05-22 Thread Pierre Couderc
data in my table so I can’t confirm the logic. You seem to want to update mother’s maiden name if her current (sur)name doesn’t match that of the father of (one of?) her children? That might be a serious leap of faith.) Now I check manually... ;) On May 22, 2019, at 6:43 AM, Pierre Couderc