SQL Server multiple table removal

The first step:

Build table

CREATE table t1 (x int, y int);
CREATE table t2 (x int, y int);
Go

INSERT into T1 (x, Y) VALUES (2,3), (3,4), (4,5), (5,6);
INSERT into T2 (x, Y) values (2,3);
Go

Step Two:

Delete Related rows in the T1 table

Delete a

From T1 as a inner joins T2 as B on a.x=b.x;

Step Three:

The second step is to remove the two lines (2,3) from the T1 table. But be careful that the delete here can delete only one table, and you cannot delete multiple tables at the same time. This is a different place from MySQL.

Fourth Step:

Multiple tables can be deleted simultaneously in MySQL

Delete A, b

From T1 as a inner joins T2 as B on a.x=b.x;

SQL Server multiple table removal