?Compare data in two tables

D

DavPet

I have two tables with identical structure.
I need to compare the tables and report the differences in data by field.
The tables are 128 columns wide. Many times there are several columns that
have differences.
Do I have to query each column separately?
How can I make all these comparisons and show the records that have
differences?
 
R

Rick B

First, Why do you have two identical tables? Why not combine them? You are
maintaining the same data in two places and hoping that updates are made to
both tables? Yikes.

Second, a table with 128 columns is VERY large. A typical table in a
relational database should contain 20 or 30 fields at the most. You may
want to rethink your database structure.
 
D

DavPet

Yeah but ..

The design is not mine (just the problem). The tables were populated by two
different groups now thay want them combined so I need to know the
differences.
128 columns wide but NO relationships, flat like a spreadsheet.

Improvements/rethinking you suggested may be the next step.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare two similar tables 2
How compare data between 2 tables 1
i want to compare two tables and find duplicates 1
Compare Data in Two Tables 2
differences between two tables 1
Query that will look for duplicate in two tables. 3
How to compare two simple fields ? 1
Compare table for changed data 1

Top