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 4 3524
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: GitarJake |
last post by:
Hello all,
I am new to sql and have some Access experience.
In sql, how do I: compare 2 identical tables, (except for data); then update
table 1 with new data from table 2
TIA
Jake
|
by: Maur |
last post by:
Hi all,
I have 2 tables say t_OLD and t_NEW. The new has
corrections for audit purposes.
They are identical in all respects (i.e. new is a copy of
old and then changes are made to t_new)
...
|
by: Megan |
last post by:
Hi everybody-
I'm helping a friend with a music database. She has an old one and is
creating a new one. She wants to compare records and fields in the old
database with records and fields in the...
|
by: Megan |
last post by:
Hi everybody-
I have 2 tables, Hearings and Rulings. Both have primary keys called,
CaseID, that are autonumbers. I don't want both tables to have the
same autonumber. For example, if Hearings...
|
by: Vincent |
last post by:
has any one seen a program to compare mdbs'. I have ran into a few of
them, but none seem to really do that job.
Basically what I need to do is, take 2 access mdb's and check the
differences...
|
by: Peter via AccessMonster.com |
last post by:
I need solution to prove and determine that Access MDE application file (in
use) is IDENTICAL with archetype MDE file, which is tested and certified
with some very restricted functionality and...
|
by: geronimo_me |
last post by:
Hi,
I am atempting to compare part of a field with the whole of another
field in access. Is this possible?
Basically I have 2 tables with the following info:
Table1
Field1 = MR.
|
by: sleepyant |
last post by:
Hi, I have 2 identical tables in each server that I need to compare and
update/insert accordingly using SQL.
For example, server A as a source and Server B as destination which both
have Table1....
|
by: somen |
last post by:
How to compare the contents of two tables of identical structure?
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |