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 ----- Original Message ----- From: "John" <[EMAIL PROTECTED]> To: "DUG" <[EMAIL PROTECTED]> Sent: Wednesday, February 04, 2004 3:27 PM Subject: [DUG] SQL > Hi, > > Can anybody tell me what the correct SQL is for the following: > > UPDATE Table1 > SET MyField = Table2.FieldA > WHERE (Table1.ID = Table2.ID AND Table2.FieldB = 0) > > > I.e.: Table1.MyField needs to be set with the value from Table2.FieldA, but > only for the records where Table2.FieldB = 0 > > > TIA > John > > _______________________________________________ > 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
