Compare fields to find missing records?

R

roihunter

How do I find records that are in one field/table but are missing in a
similar field/table? I am trying to determine which records are missing.

Thanks,
roihunter
 
M

mikesjLFG

How do I find records that are in one field/table but are missing in a
similar field/table? I am trying to determine which records are missing.

Thanks,
roihunter
Click to expand...

I already answered this the first time you posted in today.

You can run a "Find Unmatched Query". If under the queries tab click
new at the top it will allow you to select that wizard.
 
P

PatdeLux

How do I find records that are in one field/table but are missing in a
similar field/table? I am trying to determine which records are missing.

Thanks,
roihunter
Click to expand...

Use an outer join and test for null values in the primary key of the
related table.

Patrick
www.idevlop.com
 
K

knightconsulting

How do I find records that are in one field/table but are missing in a
similar field/table? I am trying to determine which records are missing.

Thanks,
roihunter
Click to expand...

if you're looking for differences in the data you can try firefly.
it's a simple tool i wrote to compare data from two sql resultsets. it
really comes in handy if you have a test db and a production db and
you're looking to see how new code will affect the data.

http://www.download.com/Firefly-Data-Compare-Tool/3000-10258_4-10645066.html?tag=lst-0-1
 
Top