update using inner join

h2newbie

unread,

Mar 12, 2014, 5:05:41 AM3/12/14

to h2-da...@googlegroups.com

i tried to do update using inner join with no luck, i always get sql syntax incorrect while in sql server it work with no problem for example

UPDATE t1 set t1.x=3

from Table1 as t1 inner join Table2 as t2 on t1.id=t2.y

where t1.z=...

Thomas Mueller

unread,

Mar 12, 2014, 3:20:14 PM3/12/14

to H2 Google Group

Hi,

I'm afraid H2 doesn't support this syntax. For the supported syntax, see http://h2database.com/html/grammar.html#update

Regards,

Thomas

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

h2newbie

unread,

Mar 13, 2014, 10:21:10 AM3/13/14

to h2-da...@googlegroups.com

ok

בתאריך יום רביעי, 12 במרץ 2014 11:05:41 UTC+2, מאת h2newbie:

Reply all

Reply to author

Forward