>>>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?