Information générale
Catégorie:
Produits tierce partie
>Just to clear things up,
>is your contact table for different addresses of the same person, or for different person one knows?
>
>i.e.
>1)
>Claude can be reached in Montreal, 555-5555
>Claude can be reached in Toronto, 666-6666
>
----------------------
The first one.....
----------------------
Actually, this I have given you as a example.. I have lot of projects in which I have same situation :-
Like ->
parent is order file which is having info. abt orders.
one child is delivery file which is having delivery dates and qty.
one child is LC which is having the LC details of particular order.
User wants to see
order no., delivery date, lc no.
same relation & same problem...
>or
>
>2)
>Claude knows Bob in Montreal, 333-3333
>Claude knows Roger in Toronto, 222-2222
>
>CL
>
>
>>
>>Name - Parent Table
>>
>>code(n,5)
>>name(c,50)
>>
>>contact - child table
>>code(n,5)
>>phone(c,10)
>>
>>address - child table
>>code(n,5)
>>Address(c,50)
>>
>>Relation is
>>name.code=contact.code and name.code=address.code
>>
>>I want a report like this:-
>>
>>name, phone, address
>>
>>For testing pupose pls fill, 1 record in name, 2 in contact for the same code and 2 in address for the same code..
>>
>>The correct result should come in 2 records but it is giving 4 records.
>>
>>I will really appreciate, if you can give me any method to achieve it through sql
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement