> 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
