Advertisement
Guest User

Untitled

a guest
Mar 28th, 2015
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. person things
  2. A TV
  3. A CAR
  4. A MOBILE
  5. A HOUSE
  6. B TV
  7. C TV
  8. C CAR
  9. C MOBILE
  10. C HOUSE
  11. D TV
  12. E TV
  13. F TV
  14.  
  15. SELECT things
  16. FROM tbl_happiness as x
  17. WHERE NOT EXISTS
  18. (
  19. SELECT person
  20. FROM tbl_happiness as y
  21. WHERE NOT EXISTS
  22. (
  23. SELECT 1
  24. FROM tbl_happiness as z
  25. WHERE z.person = y.person
  26. AND z.things = x.things
  27. )
  28. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement