SQL 删除上映时间小于 2010-01-01 且演员为苏晓的电影上映信息

DELETE FROM I WHERE idate < '2010-01-01' AND mno IN ( SELECT mno FROM R WHERE ano IN ( SELECT no FROM A WHERE name = '苏晓' ) )

原文地址: http://www.cveoy.top/t/topic/os6r 著作权归作者所有。请勿转载和采集!