Sql delete where in select

DELETE FROM tableA
WHERE ROWID IN 
  ( SELECT q.ROWID
    FROM tableA q
      INNER JOIN tableB u on (u.qlabel = q.entityrole AND u.fieldnum = q.fieldnum) 
    WHERE (LENGTH(q.memotext) NOT IN (8,9,10) OR q.memotext NOT LIKE '%/%/%')
      AND (u.FldFormat = 'Date'));

Source: stackoverflow.com

Similar codes

0 vote306 views1 answer
Cannot start database server xampp mac os
SQL
0 vote321 views1 answer
Execute sql stored procedure in powershell
SQL
2 votes318 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote300 views1 answer
Sql describe
SQL
4 votes285 views1 answer
Update table from another table oracle
SQL
2 votes311 views1 answer
Update with join sql server
SQL
7 votes301 views1 answer
Safe update mysql
SQL
0 vote275 views1 answer
Como leer datos de mysql esp32
SQL
0 vote300 views1 answer
Postgresql import a database of gzip
SQL
0 vote290 views1 answer
Mysql create table like
SQL