Guest User

Untitled

a guest
Apr 22nd, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.16 KB | None | 0 0
  1. SELECT COUNT(*) FROM "webdesk_equipmentrental"
  2. INNER JOIN "webdesk_equipment"
  3.     ON ("webdesk_equipmentrental"."equipment_id" = "webdesk_equipment"."id")
  4. INNER JOIN "webdesk_equipmentcategory" ON
  5. ("webdesk_equipment"."category_id" = "webdesk_equipmentcategory"."id")
  6. WHERE "webdesk_equipmentcategory"."reception_desk_id" = 'hutchens'
  7. ;
  8.  
  9.  
  10.  
  11.  
  12.  
  13.  
  14.  
  15.  
  16. CREATE TEMP TABLE asdf AS
  17. SELECT "webdesk_equipmentrental".id FROM "webdesk_equipmentrental"
  18. INNER JOIN "webdesk_equipment"
  19.     ON ("webdesk_equipmentrental"."equipment_id" = "webdesk_equipment"."id")
  20. INNER JOIN "webdesk_equipmentcategory" ON
  21. ("webdesk_equipment"."category_id" = "webdesk_equipmentcategory"."id")
  22. WHERE "webdesk_equipmentcategory"."reception_desk_id" = 'hutchens'
  23. ;
  24.  
  25.  
  26.  
  27.  
  28.  
  29.  
  30.  
  31. DELETE FROM "webdesk_equipmentrental"
  32. WHERE id IN asdf
  33. ;
  34.  
  35.  
  36.  
  37.  
  38.  
  39.  
  40.  
  41. SELECT COUNT(*) FROM "webdesk_equipmentrental"
  42. INNER JOIN "webdesk_equipment"
  43.     ON ("webdesk_equipmentrental"."equipment_id" = "webdesk_equipment"."id")
  44. INNER JOIN "webdesk_equipmentcategory" ON
  45. ("webdesk_equipment"."category_id" = "webdesk_equipmentcategory"."id")
  46. WHERE "webdesk_equipmentcategory"."reception_desk_id" = 'hutchens'
Add Comment
Please, Sign In to add comment