Issue with joined tables in a query

[Magnolia1]

Hello, I need help with my query. I built 2 tables: Table 1: sub account number, account name, amount paid (Record one: abc, Tree, 100; Record two: abc, Tree, 200) and Table 2: account number, sub account number, account name (Record one: 1122, abc, Tree; Record Two: 3344, acb, Tree). I joined them by sub account number and account name. I was looking to get the following answer: Account Number; Sub Account Number; Account Name; Amount;
1122 abc Tree 100
3344 abc Tree 200
but I got additional records that I do not need.


Account Number; Sub Account Number; Account Name; Amount;
3344 abc Tree 100
1122 abc Tree 100
3344 abc Tree 200
1122 abc Tree 200
How can I get read of theses additional records?
Thank you for your responses. :-)

[ssanfu]

Welcome to the forum.....

From your question I am guessing you are pretty new using Access.

Your table design has issues. If you don't fix the issues now, later on you will have major headaches.
Design your tables using paper and pencil, whiteboard, chalkboard..... you get the idea...... BEFORE you start typing in Access.

I would recommend working through these tutorials : http://www.rogersaccesslibrary.com/forum/forum46.html
Should take you about 45 minutes - actually take the time to do the tutorials.

I always use an autonumber type as my PK field.
See
Autonumbers--What they are NOT and What They Are
http://www.utteraccess.com/wiki/index.php/Autonumbers


Microsoft Access Tables: Primary Key Tips and Techniques
http://www.fmsinc.com/free/newtips/primarykey.asp

Only use letters and numbers (underscore is the exception) in object names. NO spaces, punctuation or special characters.

[Magnolia1]

ssanfu,
Thank you for your response. The links that you provided contain a lot of useful information. This is a mock up query. But it is an accurate reproduction of my issue. The tables are imported from 2 different sources and missing any/all unique values or anything that I could potentially use as a unique value. I have to come up with a work around.
Thank you again.