d2c2.1.sql 373 B

1234567891011121314
  1. SELECT f1.person2, f2.person2
  2. FROM (
  3. SELECT * FROM FriendshipSymmetric WHERE person1 = 4
  4. ) f1
  5. JOIN
  6. (
  7. SELECT * FROM FriendshipSymmetric WHERE person1 = 4
  8. ) f2 ON f1.person1 = f2.person1
  9. WHERE f1.person2 != f2.person2
  10. AND NOT EXISTS
  11. (
  12. SELECT * FROM FriendshipSymmetric f WHERE f.person1 = f1.person2 AND f.person2 = f2.person2
  13. )