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 vote238 views1 answer
Default password for mysql_secure_installation in mac
SQL
2 votes252 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote225 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
4 votes224 views2 answers
Select first and last row mysql
SQL
0 vote234 views1 answer
Sql date d'aujourd'hui
SQL
0 vote233 views1 answer
Copy value from one column to another postgres
SQL
0 vote291 views1 answer
What is metadata in sql
SQL
0 vote271 views1 answer
Alternative for LIMIT sql
SQL
5 votes234 views1 answer
Postgresql functions
SQL
-2 votes220 views1 answer
How to open database
SQL