Query data from 2 tables

[BloodshotVandal]

Hi all, I was wondering if anyone can help me with a problem I am having, namely, I have two tables:
Table A with all the names of my accounts (Account01, Account02, ...., Account10)
and
Table B that records all changes in balance that happens on those accounts and the dates when these changes occur.

I am trying to create a query that will get all the accounts from Table A and combine them with the balances from Table B at a particular date. For example, say I query the balances on 31 May 2010, I trying to get the query results to show all the accounts i.e. Account01 to Account10 and their relevant balances on 31 May 2010.

Unfortunately as there are only two entries, one for Account01 and one for Account03, on Table B for 31 May 2010, the query is only showing Account01 and Account03 and not the others.

I am currently using INNER JOIN to join the two tables.

 

[Galaxiom]

Use a Left Join or Right Join. (Right click on the join in the query designer)

 

[BloodshotVandal]

Thanks for replying GalaxiomAtHome.

Unfortunately, left/right join didn't produce the desired result, while Account01 to Account10 was listed, the changes for Account01 and Account03 was applied to all the accounts rather than just Account01 and Account03.