I have 3 tables

name having names of persons
address having addresses of persons
contact having contact nos. of persons

name is parent which is related with address by code & it is also related with contact by code.

Its one parent and 2 childs.

I want simply a report like this :-

name contact1 address1
name contact2 address2

I have one record in name, 2 in contact and 2 in address, the right result should come as 2 records

instead it is giving me four records, contact nos. and address are getting repeated.

This prob. I have already asked here when I was doing this thing through SQL & was not able to get the solution. So, I tried FoxFire and .... Result is same..