It allows you to update using a joined table's column as the source information for the target column you want to update.
-----Original Message----- From: John Singleton [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 4:17 PM To: Kevin Wilson Cc: [EMAIL PROTECTED] Subject: Re: UPDATE FROM STATEMENT NOT SUPPORTED Hi Kevin, That statement really works in SQL Server? What does it do? Try: UPDATE <table> SET <COL>=<VALUE> WHERE <CONDITIONS> JLS [EMAIL PROTECTED] wrote: >Unable to do mass update from a table using: > >UPDATE <TBL> SET <COL> = 'X' FROM <TBL A>, <TBL B> WHERE <CONDITION(S)> > >Get "Invalid end of SQL statement." on the FROM keyword. This is a real >handy item to have (use it in MS SQL Server). It may be a non-standard T-SQL >extension but I am not sure. Nonetheless, I would think that adding this to >your support sql would make many very happy. > >Cheers > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
