No idea; but perhaps you can try to start with a simpler SQL statement, and continue adding stuff until you get the error again, so that you know which part is causing the problem.

>File 'left.dbf' does not exist.
>
>
>
>>What is the error message, or the unexpected behaviour?
>>
>>>Hi all,
>>>
>>>What is bad in my command ?
>>>
>>>

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

>>>
>>>
>>>bernhart