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

9 votes235 views6 answers
Sql add column with default value
SQL
4 votes225 views1 answer
Select nls_date_format
SQL
1 vote234 views1 answer
Mysql limit results to 10
SQL
0 vote229 views1 answer
Sql combine results from two tables
SQL
0 vote267 views1 answer
Get role postgres
SQL
0 vote231 views1 answer
Xampp mysql version
SQL
0 vote243 views1 answer
How to run mysql on terminal mac
SQL
11 votes242 views1 answer
Sql query to find duplicates in column
SQL
4 votes233 views4 answers
What is primary key
SQL
0 vote240 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL