I'm trying to run something like this and I'm running into problems. Can someone tell me what the correct syntax is or if there is another way to accomplish the same thing?
UPDATE T1 SET T1.Status = 0 FROM Table1 AS T1INNER JOIN Table2 AS T2 ON T1.PID = T2.ID WHERE T1.Name = 'BOB' AND T2.Score = 10; -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
