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..