>>Thanks for your reply.. Now will you be kind enough to give me the correct sql statment...for my report..
>>Thanking you in advance...
>
>Maybe I spoke to fast but I can give it a try.
>Could you send the structure of your tables.
>
>CL

Name - Parent Table

code(n,5)
name(c,50)

contact - child table
code(n,5)
phone(c,10)

address - child table
code(n,5)
Address(c,50)

Relation is
name.code=contact.code and name.code=address.code

I want a report like this:-

name, phone, address

For testing pupose pls fill, 1 record in name, 2 in contact for the same code and 2 in address for the same code..

The correct result should come in 2 records but it is giving 4 records.

I will really appreciate, if you can give me any method to achieve it through sql