need sql help

[eluser]jedd[/eluser]
Okay, I meant could one payment span multiple bills. I know that in the past I've often done this - a bill comes in, and I'll pay less or more than is on the thing, for one reason or another, and the subsequent bill comes in showing the new amount less/plus the delta. I know one payment won't span different *companies* - but want to clarify that for any given bill there will be one or more payments, and for any given payment it will be for one bill and one bill only.

If it's the latter - that is, a payment will match to one bill and for any given bill you have one of:
o no payments associated
o one or more payments associated that total to less than the bill amount
o one or more payments associated that total to precisely the bill amount

.. then things are slightly easier - or at least clearer