Advertisement
Guest User

Untitled

a guest
May 7th, 2015
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. select
  2. a.id
  3. from
  4. master as m,
  5. aux as a
  6. where
  7. a.gid = m.groupid
  8. and
  9. a.sid = m.sectionid
  10. and
  11. not in m.groupid
  12. and
  13. not in m.sectionid
  14.  
  15. id groupid sectionid
  16. 1 A Group 21
  17. 2 A Group 23
  18. 3 B Group 55
  19. 4 C Group 999
  20. 5 D Group 52A
  21. 6 D Group 53
  22.  
  23. id gid sid
  24. 1 A Group 21
  25. 2 A Group 22
  26. 3 A Group 23
  27. 4 B Group 55
  28. 5 B Group 55A
  29. 6 C Group 999
  30. 7 D Group 52A
  31. 8 D Group 53
  32. 9 D Group 56
  33.  
  34. id groupid sectionid
  35. 1 A Group 21
  36. 2 A Group 23
  37. 3 B Group 55
  38. 4 C Group 999
  39. 5 D Group 52A
  40. 6 D Group 53
  41. 7 A Group 22
  42. 8 B Group 55A
  43. 9 D Group 56
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement