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 vote242 views1 answer
Sql check if field is not null
SQL
0 vote243 views1 answer
Parent and child link in mysql
SQL
3 votes189 views2 answers
Oracle synonym
SQL
0 vote186 views1 answer
How to Remove milliseconds from Date time
SQL
1 vote199 views1 answer
Sql padd let with zeros
SQL
0 vote221 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
2 votes190 views1 answer
Drop table if exists in postgres
SQL
9 votes218 views6 answers
Oracle substring
SQL
1 vote240 views1 answer
Mysql show long running queries
SQL
1 vote197 views1 answer
Mysql select another database
SQL