Advertisement
Guest User

Untitled

a guest
Nov 9th, 2011
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. delete from borrowers where branchcode = 'XXX';
  2.  
  3. delete from items where homebranch = 'XXX' and holdingbranch = 'XXX' and
  4. itemnumber not in (select itemnumber from issues) and itemnumber not in (select
  5. itemnumber from branchtransfers) and itemnumber not in (select itemnumber from
  6. reserves);
  7.  
  8. delete from branches where branch code='XXX';
  9.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement