Hi, There is a feature request for this kind of "delete" statement, and I will increase the priority, but it still is relatively low priority:
MySQL compatibility: multi-table delete: DELETE .. FROM .. [,...] USING - See http://dev.mysql.com/doc/refman/5.0/en/delete.html The disadvantage of this syntax is that it's not compatible with other databases. So I suggest to use a single table delete, and "where exists(...)" as Maaartin suggested. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
