Loading

deleting rows from multiple tables

anil john

13y2.1kSQL

I want to delete rows from multiple tables, i written the code as delete t1.*,t2.* from t1 inner join t2 on t1.id=t2.id where t1.id='12' ,
it gives an error as "incorrect syntax near *"

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

rasul moh13y ago
try this coding,

DELETE FROM tablename
WHERE columnname='name'

And go this website http://www.w3schools.com/sql/sql_delete.asp
pls tick correct answer and liked
Shankar M13y ago
No, you cannot use such to delete rows from multiples. You need to use individual delete
statement to delete rows from their tables.

Thanks,
Shankar