Delete all rows in a table based on another table

by 
DELETE t1 
FROM Table1 t1
JOIN Table2 t2 ON t1.ID = t2.ID;

I always use the alias in the delete statement as it prevents the accidental

DELETE Table1

caused when failing to highlight the whole query before running it.

More Related Contents:

  1. Receive an unexpected symbol error in my PLSQL query [closed]
  2. Split data of columns in (if of is not null data of is null) [closed]
  3. SQL Sum of Field [closed]
  4. SQL
  5. Subquery using Exists 1 or Exists *
  6. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  7. SQL – How to store and navigate hierarchies?
  8. Optimize query with OFFSET on large table
  9. Conditional Count on a field
  10. single fixed table with multiple columns vs flexible abstract tables
  11. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  12. Does SparkSQL support subquery?
  13. PostgreSQL: encoding problems on Windows when using psql command line utility
  14. Composite Primary key vs additional “ID” column?
  15. Saving changes after table edit in SQL Server Management Studio
  16. Logging ALL Queries on a SQL Server 2008 Express Database?
  17. SQL query to find Nth highest salary from a salary table
  18. Aggregate a single column in query with many columns
  19. How to get export output in “real” CSV format in SQL Server Management Studio?
  20. Protecting against SQL injection in python
  21. SELECT INTO using Oracle
  22. Script to save varbinary data to disk
  23. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  24. Does Postgres support nested or autonomous transactions?
  25. `show create table` equivalent in oracle sql
  26. ORA-00972 identifier is too long alias column name
  27. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  28. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?
  29. SQL Sort Order with Null values last
  30. SQLite query, ‘LIKE’

Leave a Comment