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.
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.