deleting rows from multiple tables

Question

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 *

rasul moh · Answer

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 M · Answer

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