I’m wondering if it’s possible to merge/combine find results from
multiple tables. I have a customers model and customers have invoices
and payments. I need to combine the results from the invoice and
payment tables to create a customer ledger, which looks like:
| Date Type Amount Balance
| 1/2/07 | Invoice | $200.00 | $100.00
| 1/10/07 | Invoice | $100.00 | $100.00
Is there any way to do this?