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

47 votes201 views6 answers
Add column mysql
SQL
3 votes185 views1 answer
Mssql remove column
SQL
12 votes207 views1 answer
Run mysql instance in docker
SQL
0 vote160 views1 answer
Mysql create table columns with spaces
SQL
0 vote168 views1 answer
How to save data in database in mysql node
SQL
0 vote189 views1 answer
Soql queries for not contact related account records in salesforce
SQL
6 votes183 views1 answer
Postgres get size of database
SQL
4 votes183 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote222 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote185 views1 answer
Get number of rows in every table mysql
SQL