Combining Data from two tables

[psulions83]

I am new to this forum.....I apologize if this issue has been previously covered. Any help is much appreciated.

My problem is below.

I have two tables. Table 1 has all of the lines contained in table 2.

I need to combine the tables so that it shows me the matching records from 1 and 2 as well as the non matching in table 2.

Below is my innerjoin but I am not sure how to get the rest of the records from table1 that do not match to table2

SELECT TABLE1.ContractOwner,
TABLE1.ContractName,
TABLE1.ProductStartDate,
TABLE1.ProductEndDate,
TABLE1.DISC_PCT,
[TABLE2].DISC_PCT_AMT
FROM TABLE1 INNER JOIN [TABLE2]
ON (TABLE1.ContractName = [TABLE2].ContractName)


AND (TABLE1.ContractOwner = [Table2].ContractOwner)
WHERE (((TABLE1.ProductStartDate)<=[TABLE2]![PRODENDDATE])
AND ((TABLE1.ProductEndDate) >=[TABLE2]![PRODSTARTDATE]))

[ranman256]

1 you can key the table so you don't get dupes, then add them both...
Or
2 make an OUTER join to get all items from both tables.

[psulions83]

ranman thank you for your reply.

When I do LEFT JOIN i get the same results. OUTER join I get an error.

Sorry my access skill level is low.