博客网 >

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