联合查询

T_User:                               T_Address:

 

ID   NAME                             user_id       address

---------------                         ---------------------------

1     A                                   1                shanghai

2     B                                   1                 beijing

3     C                                   2                 guangzhou

4     D                                   9                hongkong

 

 

 

 

 

***********************************************************************

 

1 :  inner  join    

  返回所有满足关联条件的记录组合

 

  ID   NAME     address

   -------------------------

   1     A           shanghai

   1     A           beijing

   2     B           guangzhou

 

 

 

 

 

***********************************************************************

 

2:  left join   

   返回的结果中,包含了T_User中的所有记录,及其对应的地址信息(若无,则以NULL 替代)   

  

  

ID   NAME      address

------------------------------------------

1     A             shanghai

1     A              beijing

2     B             guangzhou                      

3     C             NULL                

4     D             NULL

 

 

 

 

***********************************************************************

3:  right join

    与left join 结果相反!

 

 

ID         NAME      address

------------------------------------------

1           A             shanghai

1           A              beijing

2           B             guangzhou                      

NULL      NULL       hongkong         

 

 

 

***********************************************************************    

4 : full  join

   它是left join和right join的并集

 

  

ID            NAME      address

------------------------------------------

1             A             shanghai

1             A              beijing

2             B             guangzhou                      

3             C             NULL                

4             D             NULL

NULL       NULL       hongkong