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

[dodie]

---

you have IDENTICAL TABLES with different contents.
You may use NOT IN (subquery)

[anggwaponi]

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

hello ug maayong adlaw ilabi ninyo junmar, cold_fusion, zengatsu, snaxnacu, ug dodie (sa tanan pud).

salamat kaayo nga nalamdagan ug nadungagan akong nahibaw-an nga naa pud diay ni nga technique o pwede sab ing-anion paagi.

dako kaayo ning tabang sa akong mga learning ug understanding mahitungod sa sql. ug i'm sure daghan pud ang nakakuha o nakapupo sa maayong tubag ani.

by the way, sorry sab diay nga it takes time for me to answer ky unsaon ... nanginabuhi pa man sab ko.

sa maka-usa pa, daghan gyud kaayong salamat sa tanan.


cheers!

[zengatsu]

gud luck!