对，那是正确的。在这里工作正常：
CREATE TABLE table1 (id int, username nvarchar(30));CREATE TABLE table2 (id int);CREATE TABLE table3 (id int);CREATE TABLE table4 (id int);INSERT INTO table1 VALUES (1, 'Foo'),(2, 'Bar');INSERT INTO table2 VALUES (1),(2);INSERT INTO table3 VALUES (1),(2);INSERT INTO table4 VALUES (1),(2);SELECt COUNT(*) FROM table1;2SELECt COUNT(*) FROM table2;2SELECt COUNT(*) FROM table3;2SELECt COUNT(*) FROM table4;2DELETe t1, t2, t3, t4 FROM table1 as t1 INNER JOIN table2 as t2 on t1.id = t2.id INNER JOIN table3 as t3 on t1.id=t3.id INNER JOIN table4 as t4 on t1.id=t4.id WHERe t1.username='Foo' AND t1.id='1';SELECt COUNT(*) FROM table1;1SELECt COUNT(*) FROM table2;1SELECt COUNT(*) FROM table3;1SELECt COUNT(*) FROM table4;1
如果对您不起作用，则可以修改此示例以显示您遇到的问题。
