*-- 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