Internals of Physical Join Operators (Nested Loops Join, Hash Match Join & Merge Join) in SQL Server
What is Join in DBMS and what are its types?
Merge Join - SQLServerFast
join operator - Azure Data Explorer & Real-Time Analytics
Florin Rusu - Array Similarity Join
Left Outer Join DBmarlin Docs and Knowledge Base
Join - LINQ Joining Operator
sql server - What does Nested Loops join operator has to do with a Scalar? - Database Administrators Stack Exchange
A Spark Join Operator for Point-in-Time Correct Joins - Hopsworks