View Full Version : Differences in two tables


aleo
01-31-2005, 05:24 AM
Hi everybody
It is my first post here :)

I have a simple (I hope :) ) question.
I have two tables in my database.
Tables are simple and the structure is the same
Tables contain some different and some the same records
I want to create a new table (or Raport maybe) which contains differences (different records which are not in both tables)
How can it be done in the easy way?

Sorry for such stupid question but I have tried to find this forum for similar issue with the easy solution but no luck.

Thx for the reading
:)

ColinEssex
01-31-2005, 05:28 AM
Use the "Find Unmatched Query Wizard"

Col

aleo
02-01-2005, 02:04 PM
You are right of course
Huge thx :D