I mean something like this:
```SELECT cola, colb, ...
# suiteanalyticsj
jen
07/15/2020, 5:32 PMI mean something like this:
Copy code
SELECT cola, colb, (
SELECT colc
FROM transaction nested
WHERE nested.somefield = tx.somefield
ORDER BY nested.orderfield DESC LIMIT 1
) AS colc
FROM transaction tx;