sql join on Ó÷¨

A left join B µÄÁ¬½ÓµÄ¼Ç¼ÊýÓëA±íµÄ¼Ç¼Êýͬ
A right join B µÄÁ¬½ÓµÄ¼Ç¼ÊýÓëB±íµÄ¼Ç¼Êýͬ
A left join B µÈ¼ÛB right join A
table A:Field_K, Field_A1     a3     b4     ctable B:Field_K, Field_B1     x2     y4     zselect a.Field_K, a.Field_A, b.Field_K, b.Field_B from a left join b on a.Field_K=b.Field_KField_K  Field_A  Field_K  Field_B  ---------- ---------- ---------- ---------- 1     a     1     x    3     b     NULL   NULL4     c     4     z  Ò²¾ÍÊÇ˵left join ÔòÁ¬½Ó×ó±ß±íÖÐËùÓмǼ¶¼»á³öÏÖ£¬Èç¹û¸ù¾ÝÁ¬½ÓÌõ¼þÔÚtable2ÖÐÕÒ²»µ½Ïà¹Ø¼Ç¼£¬ÔòÏÔʾΪnull¡£right join ÔòÏÔʾÓұ߱íÖеÄÈ«²¿¼Ç¼¡£inner join ÔòÖ»ÓзûºÏÌõ¼þµÄ¼Ç¼²Å»á³öÏÖÔÚ½á¹û¼¯ÖС£
 
EG2¡ÃÓÐÁ½±íaºÍb£¬Ç°Á½×Ö¶ÎÍêÈ«Ïàͬ£º(id int,name varchar(10)...)id     name    ----------- ---------- 1      a     2      b     3      cÒÔϵIJéѯÓï¾ä£¬ÄãÖªµÀËüµÄÔËÐнá¹ûÂ𣿣º1.select * from a left join b on a.id=b.id where a.id=12.select * from a left join b on a.id=b.id and a.id=13.select * from a left join b on a.id=b.id and b.id=14.select * from a left join b on a.id=1½á¹û:id     name    id     name    ----------- ----------- ----------- ----------- 1      10     1      10(1 row(s) affected) id     name    id     name    ----------- ----------- ----------- ----------- 1      10     1