How to compare two identical tables in VB.NET + MS Access

[himanshupundir]

I have two identical tables, now I want to compare them and display the
results in a form which looks something like this...CaseID is primary
key and it is same for a case in both tables

Fieldname ----TableA-----TableB

CaseID 101 101
FirstName John John D
LastName White White
DOB 1-5-77 1-6-77

Thanks
HP

 

[vbnetdev]

are both tables in the same database?

 

[hp]

Yes they are in same database but with different names.

 

[hp]

Yes they are in same database but with different names.

 

[vbnetdev]

Do an inner join and compare the fields. Since the fields are of the same
name you will need ot alias one of the columns.

Link on inner joins....

for SQL http://www.w3schools.com/sql/sql_join.asp

For Access
http://www.databasejournal.com/features/msaccess/article.php/3516561