Query Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everybody,

i have two tables (Table1 and Table2) with mostlu similar information. in
order to see what is not matchin in them i created the following tables:

1) InCommon (shows matching info)
2) InTable1_butNotIn_Table2
3) InTable2_butNotIn_Table1

then i combined them (UNION ALL). It is failing to show some info which is
actually existing in one of the tables. the tables contain columns like:
"ID", "NAME" "DAYS", "HOURS", "JOBCLASSIFICATION". In select queries I
related "ID", "DAYS" and ""JOBCLASSIFICATION", as i wanted it to show exact
daily work hours foreach days of each person. The union query is showing me
not complete days of a few personnel's work days. Please help. Thanks in
advances.

"DAYS" has several entries for different days for one person.

"InTable1_butNotIn_Table2" represents entries that are in "Table1" but not
in "Table2". In this query as a lat column i put "Table1.ID" (Is Null).

"InTable2_butNotIn_Table2" represents entries that are in "Table2" but not
in "Table1". In this query as a lat column i put "Table2.ID" (Is Null).

Please help.

Thanks in advance.
 
hi,
I have not seen your date but i think you may be going
about this wrong.
there is a find unmatch query wizard. I have used it many
times to do what you are doing.
there is also a find duplicate query wizard.
try one of those.
 
Back
Top