How delete table inner join with other table in Sqlite?

by

Try to rewrite you query using subquery: In case your PK for TR_ContactResultRecord is CaseNo

DELETE FROM TR_ContactResultRecord
WHERE CaseNo IN (
  SELECT CaseNo FROM TR_ContactResultRecord a
  INNER JOIN TR_Case b
    ON (a.FireStationCode=b.FireStationCode and a.CaseNo=b.CaseCode )
  WHERE b.Update_DateTime <=20140628134416
);

More Related Contents:

  1. How to delete or add column in SQLITE?
  2. How to use ROW_NUMBER in sqlite
  3. Android – Pulling SQlite database android device
  4. How to get Top 5 records in SqLite?
  5. Insert new column into table in sqlite?
  6. How do you enable LIMIT for DELETE in SQLite?
  7. SQLite Schema Information Metadata
  8. How to create custom functions in SQLite
  9. Sqlite group_concat ordering
  10. How to get a list of column names
  11. is there a limit to the size of a SQLite database?
  12. How to generate all dates between two dates
  13. Does it matter what extension is used for SQLite database files?
  14. sqlite – How to get INSERT OR IGNORE to work
  15. How do I DROP a constraint from a sqlite (3.6.21) table?
  16. How do I add a new column in between two columns?
  17. change sqlite file size after “DELETE FROM table”
  18. Are there any reserved words in SQLite?
  19. What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?
  20. Modify a Column’s Type in sqlite3
  21. Case sensitive and insensitive like in SQLite
  22. SQLite accent-insensitive search
  23. svn cleanup: sqlite: database disk image is malformed
  24. Will SQLite performance degrade if the database size is greater than 2 gigabytes?
  25. Truncate a SQLite table if it exists?
  26. SQLite for large data sets?
  27. Integration Testing Entity Framework code first with in-memory database
  28. How to get the number of rows of the selected result from sqlite3?
  29. How to get the last index of a substring in SQLite?
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment