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

18 votes324 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote328 views1 answer
Add a new column into table
SQL
0 vote301 views1 answer
Mysql update privileges
SQL
0 vote344 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote306 views1 answer
Mariadb number format
SQL
1 vote338 views1 answer
Mamp mysql path mac
SQL
2 votes312 views1 answer
Mysql query unique column
SQL
7 votes319 views5 answers
Show details of table postgres
SQL
2 votes316 views2 answers
Enable foreign key checks postgres
SQL
1 vote365 views1 answer
Hangfire clear all jobs
SQL