I'm trying to delele with a subquery that is the same table 'carretilla' This works in SQL Server
DELETE FROM carretilla WHERE carcod IN (SELECT carcod FROM carretilla WHERE TIMESTAMPDIFF(MINUTE,carfch, NOW()) > 10 group BY carcod);
How can i do it? Thanks
Aucun commentaire:
Enregistrer un commentaire