By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,564 Members | 810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,564 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Jul 12 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
are both tables in the same database?

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

<hi************@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
>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

Jul 12 '06 #2

P: n/a
hp
Yes they are in same database but with different names.
vbnetdev wrote:
are both tables in the same database?

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

<hi************@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
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
Jul 12 '06 #3

P: n/a
hp
Yes they are in same database but with different names.
vbnetdev wrote:
are both tables in the same database?

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

<hi************@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
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
Jul 12 '06 #4

P: n/a
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/featu...le.php/3516561

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

"hp" <hi************@gmail.comwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
Yes they are in same database but with different names.
vbnetdev wrote:
>are both tables in the same database?

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

<hi************@gmail.comwrote in message
news:11**********************@b28g2000cwb.googleg roups.com...
>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

Jul 12 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.