Join Fundamentals - TechNet - Microsoft

Joins indicate how Microsoft SQL Server should use data from one table to select the rows in another table. ... A simplified ISO FROM clause join syntax is:.

technet.microsoft.com