SQL:如何删除行;当从另一个返回倍数的表中保卫“WHERE”时

Query

    DELETE FROM TEMPSchedules 
           WHERE StudentID = ( Select StudentID 
                               From Students 
                               Where Ref = 'H1007')
    DELETE FROM TEMPSchedules