Self join producing wrong results -SQL, Sql Server

Self join producing wrong results -SQL

Language: 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

edit 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

λ

                                      .NET NoSQL database for rapid development