Different types of joins in SQLSERVER

--------------------------Different types of joins-----------------------

1.FULL OUTER JOIN

SELECT * FROM [table name1] T1 FULL OUTER JOIN [table name2] T2 ON 

           T1.[column name]=T2.[column name]

DECLARE @id INT

SELECT * FROM [table name] WHERE [column name]=@id  

                 OR [column name] IS NULL