Actually..... UPDATE Table1 SET MyField = Table2.FieldA FROM Table1 JOIN Table2 ON Table1.ID = Table2.ID WHERE Table2.FieldB = 0
Neven :-) ----- Original Message ----- From: "David Brennan" <[EMAIL PROTECTED]> To: "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]> Sent: Wednesday, February 04, 2004 3:51 PM Subject: RE: [DUG] SQL > > What SQL Server? > > > > could be (yuck non ANSI join syntax) > > > > Update table1, table2 > > set table1.myfiled = table2.fileda > > WHERE (Table1.ID = Table2.ID AND Table2.FieldB = 0) > > > > or > > > > UPDATE Table1 > > SET MyField = Table2.FieldA > > FROM Table1 JOIN Table2 ON Table1.ID = Table2.ID > AND Table2.FieldB = 0 > > (Just a minor addition to Neven's otherwise correct answer ;-). > > David. > _______________________________________________ > Delphi mailing list > [EMAIL PROTECTED] > http://ns3.123.co.nz/mailman/listinfo/delphi > > > _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
