TID. NID. Addr1. Addr2. Srvc_addr
45C 123. 1 fox ln. Suit 5. 1 fox ln Suit 5
51A. 234. 21 dey rd. Bruns. 21 dey rd Bruns
51A. 234. 21 Dey rd. Bruns. 66 Mac rd Cran
51A. 234. 21 dey rd. Bruns. St 2 app dr NC
58H. 378. 9 Horse ln. Garth. 88. Yard Bost
58H. 378. 9 Horse ln. Garth. 2 abc rd connect
58H. 379. 9 Horse ln. Garth. 9 Horse ln Garth
Groupby TID and NID if not addr1+addr2 match with any one srvc_addr, then output that TID,NID
Appreciate your support