博客网 >

多表查询的左连接
作者:分类:默认分类标签:
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')
<< / 分页查询存储过程 >>

专题推荐

人生需要一场说走就走的旅行

人生需要一场说走就走的旅行

经常有朋友说,人的一生中至少要有两次冲动,一次为奋不顾身的爱情,一次为说走就走的旅行。恋爱也许需要一些缘分,而旅行的话,...

男生长得丑,除多读书,还可以做这些

男生长得丑,除多读书,还可以做这些

长得难看并不是世界末日,权力的游戏看过吧?再怎么难看你也比侏儒tyrion lannister好看,但是他是整部剧里面最...

0/200
表情验证码:

狂傲书生

狂傲书生

  • 文章总数:0
  • 画报总数:0
  • 画报点击数:0
  • 文章点击数:0
个人排行
        博文分类
        日期归档