Sounds like a one-to-many relationship so you would need to do a left or right join. Inner join is used for a one-to-one relationship.

If you want to do SUM and other functions like that then you'll need a group by.

I agree with Tony. Name your columns something useful so that in the future it won't take a manual to figure out what data is in each column.

__________________
Eric