Table Join « SQL Server / T-SQL Tutorial






4.Table Join
4.1.Table Join( 14 ) 4.7.Self join( 3 ) 
4.2.Cross Join( 4 ) 4.8.MERGE( 1 ) 
4.3.Inner join( 8 ) 4.9.One to many( 2 ) 
4.4.Left Join( 1 ) 4.10.many to many( 2 ) 
4.5.LEFT OUTER JOIN( 5 ) 4.11.APPLY( 1 ) 
4.6.RIGHT OUTER JOIN( 2 )