SQL Beispiele: insert / delete mit join

INSERT INTO Table1 (Field1, Field2)
SELECT a.Field1, b.Field2
FROM TableA a 
INNER JOIN TableB b ON a.ID = b.ID


DELETE a
FROM TableA a
INNER JOIN TableB b ON a.ID = b.ID