Deleted 表用于存储 DELETE 和 UPDATE 语句所影响的行的复本。在执行 DELETE 或 UPDATE 语句时,行从触发器表中删除,并传输到 deleted 表中。Deleted 表和触发器表通常没有相同的行。你写的改成CREATE TRIGGER del_starin_movietitle
ON movie FOR DELETE
AS
delete
from starin
where starin.movietitle = (select starin.movietitle from starin,deleted
where starin.movietitle =deleted.title)就可以了
ON movie FOR DELETE
AS
delete
from starin
where starin.movietitle = (select starin.movietitle from starin,deleted
where starin.movietitle =deleted.title)就可以了
ON movie FOR DELETE
AS
delete starin
from starin s,deleted d
where s.movietitle =d.titlego