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

15 votes217 views5 answers
Select all tables sql
SQL
0 vote182 views1 answer
Mysql show category once count how many products
SQL
1 vote210 views2 answers
This month mysql where
SQL
1 vote193 views1 answer
Error code 1292 mysql workbench
SQL
0 vote178 views1 answer
Ms sql database data size
SQL
14 votes190 views2 answers
Oracle add column with default value
SQL
2 votes199 views1 answer
Oracle list grants on procedure
SQL
0 vote234 views1 answer
Mysql config address
SQL
2 votes186 views1 answer
How to delete view in sql
SQL
1 vote195 views1 answer
Mysql text to decimal
SQL