Hi, There's also StackOverflow you could go to for help.
But, basically I think the solution is to use "IN(select pk from table(x int-=?))". Usually the learning effect is better if people find the solution themselves... Regards, Thomas On Wed, Dec 12, 2012 at 11:03 AM, Noel Grandin <noelgran...@gmail.com>wrote: > > On 2012-12-12 11:56, Penta wrote: > >> I already tried "delete from table(x int=?) t inner join mytest on >> t.x=mytest.col" and I'm sure this is wrong, not only because I have an >> error, but even because I'm not so expert in SQL and I can't even >> understand what i wrote, my previous select statement was made with a >> stupid cut & paste and I'm not proud of this but that's it. >> > > Well there is your problem in a nutshell. > Instead of cookbook coding, trying to understand SQL will let you get much > further. > > Try this: > http://www.w3schools.com/sql/**default.asp<http://www.w3schools.com/sql/default.asp> > > If you're having trouble understanding it because it's not in your native > language, install Google Chrome and the Google Chrome Translator Bar > https://chrome.google.com/**webstore/detail/google-**translate/** > aapbdbdomjkkjkaonfhkkikfgjllcl**eb<https://chrome.google.com/webstore/detail/google-translate/aapbdbdomjkkjkaonfhkkikfgjllcleb> > > > > I posted on this forum because I tried many times and I wasn't able to >> solve this problem, it's 2 years I use H2 in my project and since this I >> have 2 posts in this group, so I don't think I'm so lazy passing my time >> asking people doing my job. >> Maybe you should use more kindness in your answers, but don't worry I >> made a batch of single delete statements and I obtained what I want, so I >> will not bother you anymore. >> >> Would you rather have kindness, or have someone actually trying to help > you? > I can always just keep quiet and let you stew in your own ignorance. > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to h2-database@googlegroups.com. > To unsubscribe from this group, send email to h2-database+unsubscribe@** > googlegroups.com <h2-database%2bunsubscr...@googlegroups.com>. > For more options, visit this group at http://groups.google.com/** > group/h2-database?hl=en <http://groups.google.com/group/h2-database?hl=en> > . > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
