/****** Script for SelectTopNRows command from SSMS  ******/

来源:互联网 发布:arcgis 地图数据制作 编辑:程序博客网 时间:2024/05/20 17:07

/* Script for SelectTopNRows command from SSMS */

SELECT [DWBM]      ,[RYXH]        ,[XM]      ,[BMBM]      ,[SFZH]  FROM GZ_RY_JBXX    AS A  where (SFZH in (select SFZH from GZ_RY_JBXX AS B where B.RYBM<>A.RYBM))  order by SFZH这是查出整个库中所有在职试用期人员select  d.DWBM,d.DWMC,r.RYXH,r.XM,r.SFZH,'' JCJG  from GZ_DW_DWXX d  join GZ_RY_JBXX r on r.DWBM=d.DWBM  and r.RYZT in('01','02')
阅读全文
0 0
原创粉丝点击