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
