Atrix, Sorry, I mis-read your post. Troy's right, it's fine the way it is. I can't say why, but the "table.column" syntax helps me organize my thoughts more easily with multi-table updates.
Ben Petersen > hello again, im trying to do another sql statement but i've been told > its not possible to do it and wanted to confirm that. > > i basicly have 2 tables, the first table called NewData has account > and budget. The second table is Accounts and has account, budget and > some other columns that we need to preserve. What im trying to do is > update Accounts with the new budgets from NewData. If in NewData > there is account 3 and budget $5.00 then i need that to update account > 3 in Accounts to have a budget of $5.00. There are a few thousand of > these entires in NewData and i was hoping there was some way to do it > without a cursor loop. Something like: > > update accounts set budget=t2.budget from accounts t1,NewData t2 where > t1.account=t2.account > > what i heard exactly was "in standard SQL, multi-table update does not > exist." > > any ideas? (: > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In > the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
