Selecting similar, unique data rows from multiple MySQL Tables

Question

I have several tables that have similar fields, for example, Name and Email address:

TABLE Users (
   Name varchar(255),
   Email varchar(255),
   etc..
)

TABLE Clients (
  Name varchar(255),
  Email varchar(255),
  etc..
)

TABLE Administrators (
  Name varchar(255),
  Email varchar(255),
  etc..
)

I'd like to get a list of all names and email address, and be able to filter out duplicate addresses across tables (i.e. a client and a user may both have the same email address)

Marco · Accepted Answer · 2011-12-07 14:02:56Z

2

Well, you could try:

SELECT DISTINCT Name, Email FROM
  (SELECT Name, Email FROM Users
   UNION
   SELECT Name, Email FROM Clients
   UNION
   SELECT Name, Email FROM Administrators) p

edited Dec 7, 2011 at 14:02

answered Dec 7, 2011 at 13:52

Marco

57.7k15 gold badges135 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Marco Over a year ago

@SashiKant: no, it doesn't!! Did you try it?

Marco Over a year ago

@SashiKant: no, if you copy my query you won't get that error, absolutely not!! Now I've also tested it, so be sure it's correct :)

Sashi Kant Over a year ago

No actually I tailered it, according to the tables i m having, its working now, thanks... hey plz help me with this query stackoverflow.com/questions/8416117/…

Marco Over a year ago

@SashiKant: I don't understand: question is yours? Or is from @GSto?

Collectives™ on Stack Overflow

Selecting similar, unique data rows from multiple MySQL Tables

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related