Gossamer Forum
(Advanced Search)
for
Home : Products : Others : MySQLMan :

Duplicate emails when doing a query

May 17, 2001, 12:02 PM
manunkind
User (53 posts)
May 17, 2001, 12:02 PM
Views: 2711
Shortcut
Quote Reply
Duplicate emails when doing a query
Hello,

After I do this statement:

SELECT email FROM contact AS C, membership AS M WHERE M.type = "SUP"

I get back 2 listings of the same email address.

What am I doing wrong? Email addresses are only listed in the table "contact". Why am I getting duplicates back?

Subject Author Views Date
Thread Duplicate emails when doing a query manunkind 2711 May 17, 2001, 12:02 PM
Thread Re: Duplicate emails when doing a query 		Stealth 2645 May 17, 2001, 12:41 PM
Post Re: Duplicate emails when doing a query 		manunkind 2644 May 17, 2001, 12:54 PM