>>>*-- Remplacer lrepondant ds teleph.dbf si correspondance >>>*-- de la clé primaire teleph.iid ds repondant.dbf ( itelephoneid ) >>>UPDATE v_Teleph ; >>> SET ; >>> lrepondant = ( NVL( repondant.itelephoneid, 0 ) ) > 0,; >>> lpersonnel = ( NVL( Employee.itelephoneid , 0 ) ) > 0,; >>> lresident = ( NVL( Resident.itelephoneid , 0 ) ) > 0,; >>> lmedecin = ( NVL( medecin.itelephoneid , 0 ) ) > 0,; >>> lmutuelle = ( NVL( Mutuelle.itelephoneid , 0 ) ) > 0; >>> FROM V_Teleph ; >>> LEFT OUTER JOIN repondant ON v_Teleph.iid = repondant.itelephoneid,; >>> LEFT OUTER JOIN Employee ON v_Teleph.iid = Employee.itelephoneid,; >>> LEFT OUTER JOIN Resident ON v_Teleph.iid = Resident.itelephoneid,; >>> LEFT OUTER JOIN medecin ON v_Teleph.iid = medecin.itelephoneid,; >>> LEFT OUTER JOIN Mutuelle ON v_Teleph.iid = Mutuelle.itelephoneid >>>>>>