LOL. Touche.
(Although for an inner join I imagine the AND would work - but as you say WHERE is far more correct and that was my intention). David. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Neven MacEwan > Sent: Wednesday, 4 February 2004 4:57 PM > To: NZ Borland Developers Group - Delphi List > Subject: Re: [DUG] SQL > > > 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 _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
