|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to compare two identical tables in VB.NET + MS AccessI 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 are both tables in the same database?
-- Show quoteHide quoteGet a powerful web, database, application, and email hosting with KJM Solutions http://www.kjmsolutions.com <himanshupun***@gmail.com> wrote in message news:1152725736.410783.201090@b28g2000cwb.googlegroups.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 > Yes they are in same database but with different names.
vbnetdev wrote: Show quoteHide quote > are both tables in the same database? > > -- > Get a powerful web, database, application, and email hosting with KJM > Solutions > http://www.kjmsolutions.com > > > > <himanshupun***@gmail.com> wrote in message > news:1152725736.410783.201090@b28g2000cwb.googlegroups.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 > > Yes they are in same database but with different names.
vbnetdev wrote: Show quoteHide quote > are both tables in the same database? > > -- > Get a powerful web, database, application, and email hosting with KJM > Solutions > http://www.kjmsolutions.com > > > > <himanshupun***@gmail.com> wrote in message > news:1152725736.410783.201090@b28g2000cwb.googlegroups.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 > > 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 -- Show quoteHide quoteGet a powerful web, database, application, and email hosting with KJM Solutions http://www.kjmsolutions.com "hp" <himanshupun***@gmail.com> wrote in message news:1152734394.569119.10070@b28g2000cwb.googlegroups.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 >> >> >> >> <himanshupun***@gmail.com> wrote in message >> news:1152725736.410783.201090@b28g2000cwb.googlegroups.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 >> > > 
Other interesting topics
Validating textbox w/ Cancel button
sql server 2005 tools configuration starts when I build a distribution project (VB 2005) for next problem Outlook Add In suddenly stops loading Delegate et al TypeForwardedToApp attribute. Replacement for Inet Control text justification in excel Checked List Box Help Determine projects in solution within VS2005 macro |
|||||||||||||||||||||||
