Join two tables

[Guest]

My question sounds simple but I really had a hard time to figure out it as I
am quite new to Access. I need join two tables. The two tables has two common
values (company and product) and I need both table's records to match both
common value before they can merger together. Here they are:

Table 1
Company/Product/Test1
1/1/*
1/2/*
1/3/*
1/4/*
2/1/*
2/2/*
2/3/*
3/1/*
3/2/*
3/3/*



Table 2
Company/Product/Test2
1/4/*
2/1/*
3/3/*

After merger, my result should be:

Company/Product/Test1/Test2
1/1/*
1/2/*
1/3/*
1/4/*/*
2/1/*/*
2/2/*
2/3/*
3/1/*
3/2/*
3/3/*/*

I know it is a outer join so I set up the join property with an arrow from
bigger table to smaller table. But after running the join query, it yields no
result to me. Thanks for your help!

 

[Guest]

Why not build your table3 with all fields and make a compound key field of
the Company/Product fields.
Append from table1 and then from table2. Next do an update query using
table2 to update test2 field.