Information générale
Catégorie:
Produits tierce partie
>>Thanks for your reply.. Now will you be kind enough to give me the correct sql statment...for my report..
>>Thanking you in advance...
>
>Maybe I spoke to fast but I can give it a try.
>Could you send the structure of your tables.
>
>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