>>>>>>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 can understand you have a parent names table say holding companies, and each company has several contacts with several addresses for each contact and you want all companies and contacts with only one address per contact.. If this is right just extend your group by.
Select .... group by name,contact
Or you want all records down to addresses then do not use group by.
Cetin