Company ABC used product 101, and receive company was NY, and product was used 2 times, also ABC company has NULL product and recive company was FL, and so on with EFG and HIG company
Needs more clarity in your example.. I have just pasted 'ABC's data.
Code:
company   Product           Rec_Company
ABC          101              NY
ABC          101              CA
ABC          101              NY
ABC          101              FL
what is this 'CA'?? where is NULL product?? How do you define 'FL' is the receiver?? Is there any ID in between???