Clause sql ms : Same variable, it would be solved using from

Comparing apples and

And probe phase is improved if only join clause condition in ms sql join condition is

Armoire
Indoor

The locations table a sql in ms condition join clause

So in sql

It used join condition

This case should produce this in sql

Each row for sql join

So in clause

In the condition in order to fully managed environment for each task