>>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..
>
>
>AFAIK, I don't think this a problem of the report tool but rather that your SQL statement omits something. When using multiple tables in a SELECT statement you must be careful to specify the needed filters in the WHEN clause. Otherwise you'll get a cross product of every records of every tables.
>
>
>Claude.

Thanks for your reply.. Now will you be kind enough to give me the correct sql statment...for my report..
Thanking you in advance...