Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

InstantDB: update query error


Could someone give me an example of the correct syntax for updating the values in one table with values from another table.
They synxtax I use in several other databases, that I thought was standard to all databases is:
 
Update table1 set table1.colA = table2.colB from table2 where (table1.ID = table2.ID)
 
I get an error that the from was not expected. I have tried ever other possible combination I can think of to make this work with no luck.
Any help would be greatly appreciated.
 
Shawn Gorman
 
 
Also, on a similar note. I sometimes get an illegal mixture of string/numeric but both sides of the = are integers.