According to the following article, there is no longer a meaningful SQL standard.
http://techupdate.zdnet.co.uk/story/0,,t481-s2112216,00.html Enjoy the RBase extensions to the 92 standard. Someday, (possibly) when you are porting to another RDMS, you will need to rewrite some of your code to comply with that language. Don't sweat it now. For most of the applications you write, it will never happen (my opinion.) -- Dennis McGrath mailto:[EMAIL PROTECTED] -- Full time consultant with: SQL Resources Group Steve Hartmann Oak Park, IL mailto:[EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Atrix Wolfe Sent: Sunday, October 13, 2002 6:55 PM To: [EMAIL PROTECTED] Subject: sql query 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/
