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
