Tag: sql-delete

60 votes
16 answers
2.1K views
MySQL Error 1093 - Can't specify target table for update in FROM clause

I have a table story_category in my database with corrupt entries. The next query returns the corrupt entries:

avatar
Wei
0 1 0 9
asked 07 September, 2021
63 votes
15 answers
381 views
How can I delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, L

avatar
Jefferey
0 1 0 9
asked 07 September, 2021