Thanks to all, effectively the solution "IN(select pk from table(x int-=?))" was ridiculously simple, but I was stuck using inner join trying to replicate the select syntax without an inner query.... I'm a bit ashamed :-( Not all days are good days...
Thanks again. Il giorno mercoledì 12 dicembre 2012 12:08:24 UTC+1, Thomas Mueller ha scritto: > > 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 > <noelg...@gmail.com<javascript:> > > 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-da...@googlegroups.com<javascript:> >> . >> To unsubscribe from this group, send email to h2-database...@** >> googlegroups.com <javascript:>. >> 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 view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/Jx1lwgrWc2oJ. 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.
