Join two tables

[frankchang20]

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!

 

[Norie]

I just tried a query based on your post, here's the SQL.

SELECT Table1.Company, Table1.Product, Table1.[Test1 ], Table2.[Test2 ]
FROM Table1 LEFT JOIN Table2 ON (Table1.Product = Table2.Product) AND (Table1.Company = Table2.Company);

 

[frankchang20]

thanks a lot, that works!