多表联接join

select c.lbmc,a.xbmc,count(*) as COUNT,'0' as FLAG From  group By c.lbmc order By a.xbmc

性别:              HL_USR_ZXBZ.T_ZXBZ_XB        a
教职工基本信息:    HL_USR_GXSJ.T_JZG_JBXX       b
教职工类别:        HL_USR_ZXBZ.T_ZXBZ_JZGLB     c

 

教职工类别               性别                COUNT                FLAG

lbmc                     xbmc                count                flag

select c.lbmc,a.xbmc,count(*) as COUNT,'0' as FLAG From HL_USR_GXSJ.T_JZG_JBXX b Join  HL_USR_ZXBZ.T_ZXBZ_JZGLB c On b.jzglbm=c.lbdm Join HL_USR_ZXBZ.T_ZXBZ_XB a On b.xbm=a.xbdm group By c.lbmc,a.xbmc order By a.xbmc
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
select D.id,
      D.D_Filepath,
      D.D_title,
      D.D_userid,
      E.d_value2 as extensionname,
      D.D_extension,
      D.D_size,
      T.d_value as Typename,
      d.d_update
      from OA_document_info as d
      left join bs_dict as E
      on d.D_extension=E.d_value
      left join bs_dict as T
      on d.D_type=T.id
      where D.d_userid=" & Request.Cookies("userid").Value
     
       
          字段名                  字段名           字段名
------------------------------------------------------------------       
           D                       E                T  
        OA_document_info          bs_dict          bs_dict
---------------------------------------------------------------
select:     
          D_Filepath             d_value2         d_value
          D_title                                 
          D_userid
          D_size
          d_value
          d_update
          D_type
----------------------------------------------------------------              
 条件:    D_type===================================id                          
          D_extension============d_value
        
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－ 

join 默认就是 inner join