Hi, Sorry this is not supported right now. There is a feature request for it: http://www.h2database.com/html/roadmap.html "MySQL compatibility: update test1 t1, test2 t2 set t1.id = t2.id where t1.id = t2.id". However I can't tell you when I will implement it (probably it will take quite some time).
What you can do is: UPDATE TData SET TData.amp = (select TInfo.freq from TInfo, TNode where TData.nodeId = TNode.node_id and TData.infoid = TInfo.id and TNode.yquan = 5) where exists (select ...) This should work on all databases. Regards, Thomas On Tue, Apr 21, 2009 at 3:54 PM, jbuchberger <[email protected]> wrote: > > Hi, > > we have a query of the form > > UPDATE TData > SET TData.amp = TInfo.freq > FROM TData, TInfo, TNode > where TData.nodeId = TNode.node_id > and TData.infoid = TInfo.id > and TNode.yquan = 5 > > which works fine when executed against our SQLServer instance, but > when run on the H2 copy of the same database, I get the error "Column > TINFO.FREQ not found" although this column definitely exists. > > I also tried "MODE=MSSQLServer" on opening, but that didn't do the > trick. > > Thanks for the time - any hints welcome. > Regards, > Joerg > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
