One thing to keep in mind about R:base is that it has been SQL based since day one which was in the early 80s. The core R:base engine was written around SQL even befroe there was a standard. Then in 89 when the SQL 89 standard came out, the changes to the core R:base syntex to comply with it were minimal. Now there are some newer sql standards out, but no one adhears to them 100% because there are some things in there that just aren't practical to do.
Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 10/14/02 11:56 am >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/ ================================================ 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/
