Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
deleting rows from multiple tables
anil john
12y
1.5k
1
Reply
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 *
"
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Deleting rows from multiple tables using single sql query
Adding the Two Columns having Different Name from Two Different Tables in SQL Server