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
Post #1 of 3
Views: 2688
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?

May 17, 2001, 12:41 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
May 17, 2001, 12:41 PM
Post #2 of 3
Views: 2623
Shortcut
Quote Reply
Re: Duplicate emails when doing a query In reply to
Use DISTINCT

Regards,

Eliot Lee
May 17, 2001, 12:54 PM
manunkind
User (53 posts)
May 17, 2001, 12:54 PM
Post #3 of 3
Views: 2622
Shortcut
Quote Reply
Re: Duplicate emails when doing a query In reply to
Thank you!! :)