摘要: 通俗的讲:AleftjoinB的连接的记录数与A表的记录数同ArightjoinB的连接的记录数与B表的记录数同AleftjoinB等价BrightjoinAtableA:Field_K,Field_A1a3b4ctableB:Field_K,Field_B1x2y4zselecta.Field_K,a.Field_A,b.Field_K,b.Field_Bfromaleftjoinbona.Field_K=b.Field_KField_KField_AField_KField_B----------------------------------------1a1x3bNULLNULL4c4 阅读全文
posted @ 2009-12-22 14:12 super_mario 阅读(185) 评论(0) 推荐(0) 编辑