I have two pf are PF1 & PF2.
PF1 has 100 records & PF2 has 90 records.how to i find the unmatched records ?
PF1 Fields are typ1,typ2
Pf2 Fields are Typ3 ,typ2.
plz guide me.....
I assume that the matches would be where typ2 matches in the two files. Try either a NOT IN() subselect or an EXCEPTION JOIN.
Without more information about the purpose, that's about all that can be said. Without a business problem statement, it is too close to homework.
Tom
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 2  Replies