表的连接

--在分析器中运行看看他们的区别  
  declare   @tbl1   table(id1   char(10)   ,name1   char(10))  
  insert   @tbl1   select    
  '1','a'   union   select    
  '2','b'   union   select  
  '33','d'   union   select    
  '44','e'  
  select   '弟一','個表'   union   all  
  select   *   from   @tbl1  
  declare   @tbl2   table(id2   char(10),name2   char(10))  
  insert   @tbl2   select  
  '1','a'   union   select    
  '2','b'   union   select  
  '55','d'   union   select    
  '66','e'  
  select   '弟二','個表'   union   all  
  select   *   from   @tbl2  
  select   '内連接','記録数=','表1表２','関連の記録'   union   all  
  select   *   from   @tbl1   as   a   inner   join   @tbl2   as   b     on   a.id1   =   b.id2 --内連接  
  select   '左連接','','関連記録外','表1記録全有'   union   all  
  select   *   from   @tbl1   as   a   left   join   @tbl2   as   b     on   a.id1   =   b.id2 --左連接  
  select     '右連接','','関連記録外','表２記録全有'   union   all  
  select   *   from   @tbl1   as   a   right   join   @tbl2   as   b       on   a.id1   =   b.id2 --右連接  
  select   '全連接','','   表1和表２','所有記録'   union   all  
  select   *   from   @tbl1   as   a   full   join   @tbl2     as   b       on   a.id1   =   b.id2   --全連接  
  select   '交差連接','記録数=','表1記録数×','表２記録数'   union   all  
  select   *   from   @tbl1   as   a   cross   join   @tbl2     as   b               --交差連接