Query Problem!

[Kaspro via AccessMonster.com]

Hi all, i got a table for expenses and other for payments of expenses and
owners, and i need to make a report or table that shows all expenses and
payments of owners, but the problem is that when i make my query, it gets me
only all expenses that's been payed and other expenses which not been payed
yet isnt in the query result, and i need to make the balance sheet for my
owners to show thier balance!
Thank you all...

 

[Kaspro via AccessMonster.com]

Just to know, i tried the LEFT JOIN and it works, but that's when i join the
expenses and payments tables, but the problem that i got the owners table
which is related to the payments, that's what i cant do!