>>>As I understand it, child1 has a contact#1, and the child2 has the address of the contact#1. Next you want contact#2 from child1 and the address of contact#2 from child2. To do this you have to have a key field between child1 and child2 to link the correct address with the contact#.
>>>
>>>Then your SQL would be something like:
>>>
>>>Select parent.Name, child1.Contact, child2.address ;
>>> from parent, child1, child2 ;
>>> where parentkey=child1key and child1key=child2key ;
>>> order by .... group by .....
>>>
>>>
>>>HTH.
>>
>>Thanks, but it is coming same, here is what I am typing
>>Select name.Name, Contact.phone, address.address ;
>> from name, contact, address ;
>> where name.code=contact.code and contact.code=address.code group by name.code
>>
>>but it is giving me one record only...
>
>What do you get if you eliminate the group by?
4 records with 2 duplicates...