>>>>>No, I don't want to select duplicate records, I will tell you exactly:-
>>>>>
>>>>>Parent->Name -> 1 Rec
>>>>>Child->contact -> 2 rec (contact nos. of name)
>>>>>child->address -> 2 rec (2 address, off, res)
>>>>>
>>>>>simply I want
>>>>>Name from name, phone from contact, address from address
>>>>>same way in the second record
>>>>>
>>>>>name from name, 2nd phone from contact, 2nd address from address.
>>>>>
>>>>>Now, Pls tell me the way..
>>>>>
>>>>>SQL is not fun...Always I face problem in it...
>>>>
>>>>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...
>>
>>Try the following.
>>
>>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, contact.code
>
>I'm very sorry to disturb you again but I'm afraid the result is same....
>
>Pls advs..
How about ORDER BY name GROUP BY address?
Matt McDonnell
...building a better mousetrap with moldy cheese...