Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2015
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. delete from Likes
  2. where ID1 in (
  3. select ID1 from (
  4. select L.ID1, L.ID2
  5. from Friend F, Likes L
  6. where F.ID1 = L.ID1
  7. and F.ID2 = L.ID2
  8. except
  9. select L1.ID1, L1.ID2
  10. from Likes L1, Likes L2
  11. where L1.ID1 = L2.ID2
  12. and L1.ID2 = L2.ID1
  13. )
  14. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement