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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
