用户名:
密码:

博客网 >

多表查询的左连接
作者:分类:默认分类标签:
SELECT jzgxx.jzgbh AS 教职工编号, jzgxx.xm AS 姓名, jzgxx.xmjp AS 姓名简拼,
      jzgxx.cym AS 曾用名, jzgxx.xb AS 性别, jzgxx.mz AS 民族, jzgxx.csrq AS 出生日期,
      jzgxx.jg AS 籍贯, jzgxx.zzmm AS 政治面貌, jzgxx.xx AS 血型, jzgxx.sfzh AS 身份证号,
      jzgxx.hyzk AS 婚姻状况, jzgxx.gzsj AS 工作时间, jzgxx.gzbm AS 工资编码,
      jzgxx.gwjb AS 岗位级别, jzgxx.gws AS 岗位数, jzgxx.gotq AS 港澳台侨,
      jzgxx.dabh AS 档案编码, jzgxx.byxx AS 毕业学校, jzgxx.zgxl AS 最高学历,
      jzgxx.hdsj AS 获得时间, jzgxx.zgxw AS 最高学位, flsz.mc AS 职称,
      jzgxx.tgsj AS 通过时间
FROM jzgxx LEFT OUTER JOIN
      flsz ON jzgxx.zc = flsz.lb
WHERE (flsz.zd = 'jzgxx_zc')
博客网 博客网 00
<< / 分页查询存储过程 >>
0/200
表情验证码:

狂傲书生

狂傲书生

  • 文章总数:0
  • 文章点击数:0
  • 评论数:0
  • 支持数:0
  • 反对数:0
个人排行
        博文分类
        日期归档