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]
