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