Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

stumped with sql

Status
Not open for further replies.

exc

Technical User
Jun 6, 2001
6
0
0
US
i have one table that keeps the ending balance on a customer's account.

i have another table that keeps the ledger for all events.

if the ending balance on the account is negative (ie we owe the customer money i want to pull the account. that is easy.

but i want to filter the selection even more by getting only those accounts that have payments made but no debits to the account. that is...i want to know if the customer's are paying on accounts that have nothing assessed to them.

i am at a loss as to how to do this in cr using sql...can it be done?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top