>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.
Mark McCasland
Midlothian, TX USA