I have been posting SQL Server`s query Optimizers internal details for sometimes, it is one of them in the series Nested Loop Join in SQL Server.