• Thanks for your replay.

    I use this query below :

    Select A.AccountID, A.OpenDate,

    'Amount'=(Select Top 1 TransactionAmount From Transaction Where AccountID=A.AccountID order by TransactionDate desc)

    From Account A

    or

    any idea else ?