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 vote155 views1 answer
Enable sql server full text indexing
SQL
14 votes145 views2 answers
Sql cast
SQL
0 vote148 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote146 views2 answers
Zsh: command not found: mysq
SQL
2 votes128 views1 answer
Can you use a where clause for a child query
SQL
51 votes384 views6 answers
Installing mysql on ubuntu
SQL
1 vote140 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote145 views1 answer
SQL FROM-Klausel
SQL
1 vote135 views4 answers
Sequelize migration default value
SQL
5 votes129 views2 answers
Create table
SQL