Detail transactions with multiple tables
Posted on 2007-10-03
I am trying to show the detail records for each transaction for debits and credits. Tables are as follows:
Users (userid, username)
Credits (creditid, userid, amount)
Debits (debitid, userid, amount)
How do I show it in a table as follows.
Username = "John Doe"
user credits debits
John Doe 0 10