I was in a mysql chat room asking about this and just FYI mysql (which is a pretty decent database used in the open sourced community) does not support that cross table updating until the next version. I wonder what else RBase can do which other DB's cant.
The more i learn, the more i like. Cant wait for it to go to linux though! (: its working 100% now, thanx again for the help ----- Original Message ----- From: "Ben Petersen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 2:30 AM Subject: RE: sql query > 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/ > ================================================ 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/
