Hello there, I am trying to select email addresses from table A and Table B wanting the results to be displayed taking out duplicate emails.

Currently I could see the duplicate emails in both tables via this query

Select t1.email, t2.email From tableA as t1, tableB as t2 WHERE t1.email = t2.email; That return the duplicates....

BUT

When i replace the "!=" in NOT equal comman in the place of the = command in the where clause it blows up on me...

What am i doing wrong?

Also what if I want to take tableA and TableB email address and throw them in a new table with out the duplicates, how can i do that?

Thank you for all your help....

Hey
First of all != works ..I tried and works for same query. Second thing is that can you explain your second question with example..I mean in table A and B contains only email id's or anything else ..some kind of different unique id etc?
saper

Saper,
THanks for responding...

THe != does not work for me, it takes almost 15 minutes to return the results and the results are all duplicates which from a database of 7000 records, it returns almost 1,000,000 records back, thats just impossible... Furthermore, thats the exact query that i run...

select t1.email, t2.email FROM tableA as t1, tableB as t2 WHERE t1.email != t2.email;

Can you tell me if there is anything wrong with what I just wrote?
Moreover, in regards to the second part of my question, I want to throw the results that I received from my query into a new table renames to new_email_addressed, so how do i go about doing that... Also when I receive the results of my query in two coloumns(1st coloumn being results of t1, and second results of t2) how do i go about takeing the two results and inserting them into a temparay table? I don't really have an example cause i really can't understand how mysql can do it...

THanks for all your help.

Well to answer your first question you could use

  (SELECT DISTINCT t1.email FROM tableA as t1)
    UNION
  (SELECT DISTINCT t2.email FROM tableB as t2)


That should produce a UNIQUE list of ALL emails from both tables. You don't need to show both t1.email and t2.email on the same select (as your original shows). In both of your conditions you would either have the same email for BOTH t1 and t2 (when WHERE is an EQUALS) which is redundant, or you would have a huge (depending upon your db entries) list of completely different emails with each row (when the WHERE is NOT EQUAL). In this case you would be matching up EACH email (one at a time) from tableA with EACH (and EVERY) email from tableB . This is why your query (as you put it) blew up. It didn't blow up, it's just a lot of work, and of course you now have duplicates.

The use of the UNION and DISTINCT keywords in the SQL achieves (I believe) your result.

For your NEXT quesiton (Assuming you want ONLY email addresses in the new table) you could do this:

  INSERT INTO tableC
  (SELECT DISTINCT t1.email FROM tableA as t1)
    UNION
  (SELECT DISTINCT t2.email FROM tableB as t2)

This ASSUMES tableC is already created and can handle the data expected and that there is ONLY ONE column.

Good luck


Paul Gardner
------------------
PHP-LIVE help
Via Web @ http://www.mnetweb.co.uk/irc
Via IRC Client pgardner.net:6667
room #PHP

Paul, thanks a bunch for your expertise and solution to my delimma...

Take care.
Dungey