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

1 vote217 views6 answers
In sql
SQL
5 votes237 views4 answers
Change auto increment mysql
SQL
9 votes239 views2 answers
Nosql databases
SQL
0 vote233 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote233 views1 answer
Import excel to sql
SQL
0 vote238 views1 answer
Mysql timediff
SQL
0 vote224 views1 answer
Not between mysql
SQL
5 votes253 views4 answers
SQL Order of execution
SQL
6 votes251 views4 answers
Mysql group by date
SQL
0 vote221 views1 answer
Min mysql
SQL