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 vote200 views2 answers
Sql where is not number
SQL
-1 vote220 views5 answers
Left join
SQL
10 votes204 views2 answers
Mysql alter add foreign key
SQL
0 vote197 views1 answer
Drop all triggers oracle
SQL
0 vote195 views1 answer
Sql server udf performance
SQL
0 vote213 views1 answer
Print boolean in plsql
SQL
0 vote197 views1 answer
Mysql uuid
SQL
5 votes199 views2 answers
Oracle timestamp to date
SQL
1 vote195 views1 answer
Postgres first_value in gropby
SQL
0 vote183 views1 answer
Redirection 301 htaccess nom de domaine
SQL