Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme 

Self join producing wrong results -SQL

Language: Editor: Layout:
View schema
Execution time: 0,03 sec, rows selected: 4, rows affected: 7, absolute service time: 0,22 sec, absolute service time: 0,21 sec 
fork mode |  history  | discussion
   CID packet_id packet_id packet_status
1 1001 20 21 OPEN
2 1001 15 21 CLOSED
3 1001 20 16 OPEN
4 1001 15 16 CLOSED