3 replies

Delete from join

Is it possible to do something like this:

DELETE P
  FROM Product P
  LEFT JOIN OrderItem I ON P.Id = I.ProductId
 WHERE I.Id IS NULL

DELETE P
  FROM Product P
  LEFT JOIN OrderItem I ON P.Id = I.ProductId
 WHERE I.Id IS NULL

With the ORM?
e.g.

DB.delete(Product).leftJoin(OrderItem, eq(Product.id, OrderItem.productId).where(...);

DB.delete(Product).leftJoin(OrderItem, eq(Product.id, OrderItem.productId).where(...);

Or do I need to write the full SQL statement in raw sql?