Access Quering

[albert1992]

Hello all,

I have two tables which I am trying to join, the first table is a single column and contains about 30K records with some duplicates. The second table contains this same column and a second column that I am trying to match.
However I only want to populate the first table that has about 30K records and produce a final table that has two columns.

I am attempting a left join but I am getting way too many records.

 

[Joe4]

It sounds like you have a many-to-many relationship, which means you may end up with more records than you started.
If you have a one column table, what use is it to have duplicates in it? Seems to me like you want to eliminate those first.

And it isn't quite clear exactly what you are after. It may be helpful to post small samples of each table and your expected results. You can do Copy and Paste from the Table/Queries that will look like this:

ID	Premium Receipt Total	TradeDate
0001	5	1/1/2015
0001	6	1/11/2016
0003	25	1/11/2016
0004	50	7/1/2015

<tbody>
</tbody>