Skip to content

Instantly share code, notes, and snippets.

@sbstp
Created March 26, 2013 16:27
Show Gist options
  • Save sbstp/5246820 to your computer and use it in GitHub Desktop.
Save sbstp/5246820 to your computer and use it in GitHub Desktop.
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment