I assume your tables are something like
Payments - has fields TransactionNumber, AmountPaid
Receipts - has fields TransactionNumber, ReceiptAmount, Detail, Date
In which case your sql would go something like
This will give you one table with all of your results, then you just show the values in the applicable columns.
SELECT * FROM Receipts INNER JOIN Payments ON Receipts.TransactionNumber=Payments.TransactionNumber ORDER BY Receipts.Date DESC
Sorting by date should still work because the text 20030501 is still greater than text 20030401, therefore it will come to the top.
P.S. You're right, it is more of an SQL/Database question than an ASP question
How can I soar like an eagle when
I'm flying with turkey's?