Deleting rows from multiple tables using single sql query
Plz help me:
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 *"