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
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/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+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
