Comparing data between two tables

  • Thread starter Thread starter gatarossi
  • Start date Start date
G

gatarossi

Dear all,

In my access database there are two tables. The first one has complete
information: customer_code, item_code, item_code_2, company, and
values. The second has only the item_code, item_code_2 and values.

Now I need to compare the values between the tables, but I have a big
problem: I need the all data in the first table, and when I execute
the consult the values stay in duplicity. I already think in create
another table, but I don't know... because I have some data in one table
that I don't have in another...

How can I solve this problem?

Thanks a lot!!!

André.
 
Dear all,

In my access database there are two tables. The first one has complete
information: customer_code, item_code, item_code_2, company, and
values. The second has only the item_code, item_code_2 and values.

Now I need to compare the values between the tables, but I have a big
problem: I need the all data in the first table, and when I execute
the consult the values stay in duplicity. I already think in create
another table, but I don't know... because I have some data in one table
that I don't have in another...

How can I solve this problem?

Thanks a lot!!!

André.
Click to expand...

use an outer join. And having item_code_# sounds a LOT like a
normalization problem... that should be in a separate table.
 
Back
Top