Join two tables

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

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!
 
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.
 
Back
Top