tblClients - ClientID (PK)
tblPayments - PaymentID (PK)
Thanks for any help,You can add a timestamp column to the table and then use Max(TimestampCol) to return the last inserted record (which i assume you want to return), e.g.
|||You're going to have to date stamp your transactions.
SELECT
*
FROM
myTable
WHERE
myTable.TimestampCol = (SELECT Max(TimestampCol) FROM myTable)
No comments:
Post a Comment