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