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 [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]