>One result set is equivalent to another, and as long as you aren't using unnecessary nested loop joins or such, there are a dozen ways to solve a query.
If they consume similar resources I'd almost always opt for the simplest one to understand.
In cases where the simpler one is less efficient, I might still use it if the task didn't require absolute optimization.
If they consume similar resources I'd almost always opt for the simplest one to understand.
In cases where the simpler one is less efficient, I might still use it if the task didn't require absolute optimization.