>hi all,
>
>i have the first table ( cf crytal1115.jpg in the attachemnt )
>i have the second table temp.dbf ( cf temp.jpg in the attachment ).
>
>i want update the field nclass from crytal1115.dbf with the value included from temp.dbf
>
>this do'nt works...
>
>

> UPDATE crystal1115 SET nClass = NVL( dt1.nClass , 0 ) FROM force;
>        crystal1115 inner JOIN( SELECT tp2.iPlpId , tp2.nClass FROM Temp tp2;
>        WHERE tp2.iPlpId = crystal1115.iPlpId ) dt1	ON dt1.iPlpId = crystal1115.iPlpId
>

>
>thank in advance for the answer
>
>bernhart

UPDATE crystal1115 SET nClass = NVL(Temp.nClass , 0 );
       FROM crystal1115;
INNER JOIN Temp ON Temp.iPlpId = crystal1115.iPlpId