博客网 >

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

专题推荐

七夕,怒放在盛夏的浪漫

七夕,怒放在盛夏的浪漫

有美一人,清扬婉兮。邂逅相遇,适我愿兮。这是《诗经》里的吟唱邂逅爱情的感觉。千百年过去了,人们依然在等待这种邂逅

为心爱的人做顿早餐

为心爱的人做顿早餐

赵咏华的一首老歌《早餐》里唱到:“心情特别好的早上,提前半个小时起床,为心爱的人做顿早餐,要他把我的爱一口一口吃完。”—...

0/200
表情验证码:

狂傲书生

狂傲书生

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