博客网 >

多表查询的左连接
作者:分类:默认分类标签:
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
个人排行
        博文分类
        日期归档