matching two table(s) with the same fields but different contents by sql

[anggwaponi]

---

hello all.

i would like to inquire or ask an assistance how to queries two (2) tables with the same number of fields, as well, the same header (did i say the right word) but has different contents?

its like table GardenA and GardenB ... the main query i would like to acquire is the column name emailaddress.

i want to find out if the email addresses in GardenA is not present in GardenB ...

it just happened that i want to send an email to those email addresses that has not yet been send yet (even once) any messages in both tables.


hope i can be enlighten ...


cheers!

[maddox22]

You can try using joins.

e.g.

SELECT t1.email, t2.email
FROM table1 t1
LEFT OUTER JOIN table2 t2
ON t1.email=t2.email

loop through the result set and find where t2.email is null.

[UtOkbOlinAO]

unsay database nimo??

oracle, sql, mysql or what?

[maddox22]

also... why do you have two identical tables? why not have only one table with a flag whether an email address has been notified or not?

[UtOkbOlinAO]

sakto lagi ka bro... hahaha... trabaho naka bro?

[anggwaponi]

sakto lagi ka bro... hahaha... trabaho naka bro?

hello again guys

thanks to all who have contributed to these inquiry of mine.

it surely a great of help. cheers!



p.s. happy weekend also

[junmar]

A simpler query would be
"select * from table1 except select * from table2 ".
This is an assumption that you are using an SQL Server Database. In this case, you can compare one or more fields between two tables.
But the above code is not that accurate when you are really to find the difference between two tables. It would take a higher step than just using "outer join" or "except" operator. "Left Outer Join" or "except" only checks one direction from Table1 to Table2. How about the differences between Table2 to Table1?
If you are interested on how to check and compare two tables you may follow this link:SQL Server 2005: Using EXCEPT and INTERSECT to compare tables

[cold_fusion]

Use subselect:
select * from gardenA where gardenA.email not in (select email from gardenB)
union all
select * from gardenB where gardenB.email not in (select email from gardenA)

[zengatsu]

Use subselect:
select * from gardenA where gardenA.email not in (select email from gardenB)
union all
select * from gardenB where gardenB.email not in (select email from gardenA)

if i were u, id go with this solution..

[snaxnacu]

if i were u, id go with this solution..

I agree with this solution, safe and fast..