SQL Server 2008 R 2——内部接続左接続右接続全接続交差接続

 SELECT * FROM Table_A
 GO
 SELECT * FROM Table_B
 GO
 
 --   
 SELECT a.*, b.* FROM Table_A a JOIN Table_B b ON a.ID = b.ID
 SELECT a.*, b.* FROM Table_A a INNER JOIN Table_B b ON a.ID = b.ID
 GO
 
 --         from   
 SELECT a.*, b.* FROM Table_A a INNER JOIN Table_B b ON a.ID = b.ID
 SELECT a.*, b.* FROM Table_A a, Table_B b WHERE a.ID = b.ID
 
 --   
 SELECT a.*, b.* FROM Table_A a LEFT JOIN Table_B b ON a.ID = b.ID
 SELECT a.*, b.* FROM Table_A a LEFT OUTER JOIN Table_B b ON a.ID = b.ID
 GO
 
 --   
 SELECT a.*, b.* FROM Table_A a RIGHT JOIN Table_B b ON a.ID = b.ID
 SELECT a.*, b.* FROM Table_A a RIGHT OUTER JOIN Table_B b ON a.ID = b.ID
 
 --A   B     B   A
 SELECT a.*, b.* FROM Table_A a LEFT JOIN Table_B b ON a.ID = b.ID
 SELECT a.*, b.* FROM Table_B b RIGHT JOIN Table_A a ON a.ID = b.ID
 
 --   
 SELECT a.*, b.* FROM Table_A a FULL JOIN Table_B b ON a.ID = b.ID
 SELECT a.*, b.* FROM Table_A a FULL OUTER JOIN Table_B b ON a.ID = b.ID
 
 --   WHERE                     。
 SELECT a.*, b.* FROM Table_A a CROSS JOIN Table_B b 
 
 --      WHERE   ，                  
 SELECT a.*, b.* FROM Table_A a CROSS JOIN Table_B b WHERE  a.ID = b.ID
 SELECT a.*, b.* FROM Table_A a INNER JOIN Table_B b ON a.ID = b.ID