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 ?

What about vice versa condition?

For example, I have two tables. First, a table for list of accounts. Second, a table for list of account's transactions.

I want to get the last...