Sorry i wasn't clear the first time. Hope the below example will make my question clear:
person1(Id:1, Name:John, Addr:3 Main st, City:Chicago, State:IL)
person2(Id:2, Name:Mike, Addr:12 6th st, City:San Francisco, State:CA)
person3(Id:3, Name: Diana, Addr:1635 Auburn Bl, City: Portland, State: OR)
comp1(Id:1, Company:XYZ, Position: Programmer)
comp3(Id:3, Company:HTC, Position:Sales Manager)
comp10(Id:10, Company:ABC, Position:Manager)
member1(Id:1, Name:John, Addr:3 Main st, City:Chicago, State:IL, Company:XYZ, Position: Programmer)
member2(Id:2, Name:Mike, Addr:12 6th st, City:San Francisco, State:CA, Company:, Position: )
member3(Id:3, Name: Diana, Addr:1635 Auburn Bl, City: Portland, State: OR, Company:HTC, Position:Sales Manager)
member10(Id:10, Name:, Addr:, City:, State:, Company:ABC, Position:Manager)
Information for Ids 1 & 3 are merged together. ID 2 has only person info and ID 10 has only company info.
[ December 09, 2008: Message edited by: Aravind Ramanujam ]