Comparing data between two tables

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

 

[pietlinden]

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

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