• 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 transaction amount from second table for each of account in the first table.

    How about that? Which one of those queries I might choose?

    Thanks.