>>>>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...
>>>
>>>
>>>select distinct name, contact_code, address from parent ;
>>> right join child1 on parent.code = child1.code ;
>>> right join child2 on parent.code = child2.code ;
>>> where parent.name = 'whatever'
>>>
>>
>>Thanks for the code, but Right Join (??), Are you sure this will work in
>>VFP 3.0b ??
>
>sorry. i suppose converting to 5 is not an option?

know, I'm missing lot of features...but...

Have to convince by Boss, Very difficult...:)