How to delete a row from a table using a join SQL

Question

DELETE FROM Table1
INNER JOIN View1 ON Table1.ID = View1.ID
WHERE Table1.ID = View1.ID;

error is SQL command not ended properly

possible duplicate of [How Delete using INNER JOIN with SQL Server?](http://stackoverflow.com/questions/16481379/how-delete-using-inner-join-with-sql-server) — Jon Egerton, Dec 16 '13 at 11:03

score 1 · Answer 1 · answered Dec 15 '13 at 19:17

1

Specify the table where you want to delete the records,

DELETE Table1                        -- <== this will delete records from Table1
FROM   Table1
       INNER JOIN Table2 ON Table1.ID = Table2.ID
WHERE Table1.ID = Table2.ID;

answered Dec 15 '13 at 19:17

John Woo

258,903
69
498
492

Still not ended properly! I've edited the SQL, Table2 was actually a View. – meltonCG Dec 15 '13 at 19:21

score 1 · Answer 2 · answered Dec 15 '13 at 19:37

1

DELETE Table1
FROM   Table1
INNER JOIN View1
ON Table1.ID = View1.ID;

answered Dec 15 '13 at 19:37

Sampat Badhe

8,710
7
33
49

score 1 · Accepted Answer · answered Dec 15 '13 at 19:41

1

How you do this depends on the dialect of SQL. Here is a method that should work in any database:

DELETE FROM Table1
WHERE Table1.Id in (select Id from View1);

answered Dec 15 '13 at 19:41

Gordon Linoff

1,242,037
58
646
786

How to delete a row from a table using a join SQL

3 Answers3