May 8th, 2003, 02:26 AM
Join Date: Feb 2003
Location: Melbourne, Australia
Time spent in forums: < 1 sec
Reputation Power: 11
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
SELECT * FROM Receipts INNER JOIN Payments ON Receipts.TransactionNumber=Payments.TransactionNumber ORDER BY Receipts.Date DESC
This will give you one table with all of your results, then you just show the values in the applicable columns.
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?