Update query problem (Oracle)

Hi everyone. The scenario: Table1 Table2 Field_01, <- Same as -> Field_01, Field_02, <- Same as -> Field_02, Field_03, <- Same as -> Field_03, Field_04, <- Same as -> Field_04, Field_05, Field_05, Field_06, Field_06, Field_07, Field_07, Field_08, Field_08, Field_09, Field_09, Field_10, Field_10, Field_11, Field_12, Field_13, Field_14, Field_15, Field_16, Field_17, Table1 contains lot of records but Table2 contains just a few. The first 4 fields identify records that are common to the 2 tables. My problem is to write a query that updates for example Table1.Field_11 with Table2.Field_06 Table1.Field_14 with Table2.Field_09 Table1.Field_15 with constant char 'A' Table1.Field_16 with SYSDATE only for records that are both present on the 2 tables. Regards. ------------------------------------------------------------------- "On a day not different than the one now dawning, Leonardo drew the first strokes of the Mona Lisa, Shakespeare wrote the first words of Hamlet, and Beethoven began working on his Ninth Symphony, and Windows98 .... aaarrrggghhh crashed for the n'th time" ------------------------------------------------------------------- Francesco D'Inzeo WinTech S.r.l. Via Lisbona 7 35127 PADOVA (Italy) Tel. (+39)-(0)49-8703033 Fax. (+39)-(0)49-8703045 Mobile (+39)-(0)348-2867140 e-mail f.dinzeo@wintech.it