you've almost got it m. unfortunately, once you switch to using the IN condition, you can no longer pull the other data from LVCalls (disposition, call date) because they're still not part of the from statement.

you really do have to use one of the techniques mentioned (apply, row_number, CTE). 🙁