UPDATE Resident ; SET NoitelephoneIdReportActif ; = NVL((SELECT F.ireport FROM cFiltre F WHERE F.itelephoneid=Resident.itelephoneid AND F.ireport = noreport),0)bernhart
>noreport = 19 >SELECT Resident >SCAN > REPLACE NoitelephoneIdReportActif ; > WITH IIF(LOOKUP(cFiltre.ireport,itelephoneid,cFiltre.itelephoneid)=m.noreport,m.noreport,0) >ENDSCAN >* OR > REPLACE IN Resident ALL ; > NoitelephoneIdReportActif ; > WITH IIF(LOOKUP(cFiltre.ireport,itelephoneid,cFiltre.itelephoneid)=m.noreport,m.noreport,0) >* OR if supported >UPDATE Resident ; > SET NoitelephoneIdReportActif ; > = NVL((SELECT F.ireport FROM cFiltre F WHERE F.itelephoneid=Resident.itelephoneid AND F.ireport = m.noreport),0) >* OR if F.itelephoneid,F.ireport is primary >UPDATE R SET NoitelephoneIdReportActif = NVL((F.ireport,0); > FROM Resident R LEFT JOIN cFiltre F WHERE F.itelephoneid=R.itelephoneid AND F.ireport = m.noreport >