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 vote303 views1 answer
Sql select maximum column with other columns returned
SQL
1 vote345 views1 answer
Sql select all from one table and one column from another
SQL
1 vote517 views3 answers
Create table from existing table in sql
SQL
1 vote329 views1 answer
Importance of comment in mysql
SQL
0 vote322 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote363 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote332 views1 answer
Mysql search multiple tables
SQL
9 votes336 views4 answers
How to create new user and database postgresql in ubuntu
SQL
2 votes352 views1 answer
Mysql application.properties spring boot
SQL
0 vote347 views1 answer
Sql alchemy escape ; in insert statement
SQL