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