Duplicated Values

[Rolando São Marcos]

Hello.

I have the following tables:
-- Contact(Idcontact, Type, Refidpartner)
-- Address(Refidcontact, Address, Postalcode)
-- Email(Refidcontact, Address)
-- Telephone(Refidcontact, Number)

Tables Address, Email and Telephone are subtypes of the type Contact.
I would like to know if with this configuration i can make, for instance, a
search to determine what is the address of the partner X and what is his
email and telephone number.
I had try already to do so, but i get duplicated values in the resulting
table.
For instance, the partner X could have two diferent addresses or email or
telephone numbers.
How can i solve this problem?
Is it the search i made, wrong?

Thanks again.

 

[Rick B]

Yes you can. You say that Partner X could have 2 addresses. Well, you will
get two results to your query.


1) What does your query look like?
2) What are the results?
3) What do you expect the results to be?

 

[Nery Gonzalez]

I answer your post on microsoft.public.pt.sql
please check it up and let me know if it's of any use.

 

[fernando ortiz perea]

no hablo en ingles me lo podrias enviar en español