多表联接join

来源：互联网发布：怎么去演艺公司知乎编辑：程序博客网时间：2024/05/01 06:03

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