TSQL Execution Plan
Hash Match
use each row from the top input to build a hash table, and each row from the bottom input to proble into the hash table, outputting all matching rows.
use each row from the top input to build a hash table, and each row from the bottom input to proble into the hash table, outputting all matching rows.