Re: Update query problem (Oracle)

Hi Francesco, Probably the easiest way is to load the records from table 2 into an array and then lopp through updatign table 1 HTH Steve At 9:37 AM +0200 28/3/01, Francesco D'Inzeo wrote:

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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

-- --------------------------------------------------- "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: hts@hts.com.au Tel: 612 9982 6767 Fax: 612 9981 3081