gistfile1.sql

use immeuble
 
Begin tran
 
select * from locataire
delete from locataire
where no_appart in (
        select no_appart from appart_extra
        where no_extra = 8)
select * from locataire

select * from stationnement
delete from stationnement
where no_appart in (
        select no_appart from appart_extra
        where no_extra in (9,10))
select * from stationnement

rollback tran