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.