SQL Server uses three physical join operators, listed as follows, to interpret the query you execute:
None of the physical join operators are the "best" or "worst" for all situations. SQL Server 2012 chooses appropriate operator to perform query in an appropriate way. Join operators are being used in SQL Server from earlier versions and is still available in SQL Server 2012 without any change.
Let us have short introduction of each join operator: