全员数据库错误项查询方法

《全员数据库错误项查询方法》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、全员数据库错误项查询方法全员数据库错误项查询方法1、未婚有生养信息查询主表：基本情况查询条件：家庭子女vjbxx.hyzk='10'andsyjjtzn.znhc>'0'2、与户主关系与性别不符查询条件：（点击查询主表，查询条件两项都是“基本情况”，之后复制下面的命令及选择的查询字段，即可查询明细）(vjbxx.yhzgx='11'andvjbxx.xb='2')or(vjbxx.yhzgx='12'andvjbxx.xb='1')or(vjbxx.yhzgx='21'andvjbxx.xb='2')or(vjbxx.yh

2、zgx='22'andvjbxx.xb='2')or(vjbxx.yhzgx='23'andvjbxx.xb='2')or(vjbxx.yhzgx='24'andvjbxx.xb='2')or(vjbxx.yhzgx='25'andvjbxx.xb='2')or(vjbxx.yhzgx='26'andvjbxx.xb='2')or(vjbxx.yhzgx='27'andvjbxx.xb='2')or(vjbxx.yhzgx='28'andvjbxx.xb='2')or(vjbxx.yhzgx='29'andvjbxx.xb

3、='2')or(vjbxx.yhzgx='31'andvjbxx.xb='1')or(vjbxx.yhzgx='32'andvjbxx.xb='1')or(vjbxx.yhzgx='33'andvjbxx.xb='1')or(vjbxx.yhzgx='34'andvjbxx.xb='1')or(vjbxx.yhzgx='35'andvjbxx.xb='1')or(vjbxx.yhzgx='36'andvjbxx.xb='1')or(vjbxx.yhzgx='37'andvjbxx.xb='1')or(vjbxx.yhzgx

4、='38'andvjbxx.xb='1')or(vjbxx.yhzgx='39'andvjbxx.xb='1')or(vjbxx.yhzgx='41'andvjbxx.xb='2')or(vjbxx.yhzgx='42'andvjbxx.xb='1')or(vjbxx.yhzgx='43'andvjbxx.xb='2')or(vjbxx.yhzgx='44'andvjbxx.xb='1')or(vjbxx.yhzgx='45'andvjbxx.xb='1')or(vjbxx.yhzgx='46'andvjbxx.xb='2

5、')or(vjbxx.yhzgx='47'andvjbxx.xb='2')or(vjbxx.yhzgx='48'andvjbxx.xb='1')or(vjbxx.yhzgx='51'andvjbxx.xb='2')or(vjbxx.yhzgx='52'andvjbxx.xb='1')or(vjbxx.yhzgx='53'andvjbxx.xb='2')or(vjbxx.yhzgx='54'andvjbxx.xb='1')or(vjbxx.yhzgx='55'andvjbxx.xb='2')or(vjbxx.yhzgx='5

6、6'andvjbxx.xb='1')or(vjbxx.yhzgx='57'andvjbxx.xb='2')or(vjbxx.yhzgx='58'andvjbxx.xb='1')or(vjbxx.yhzgx='61'andvjbxx.xb='2')or(vjbxx.yhzgx='62'andvjbxx.xb='1')or(vjbxx.yhzgx='63'andvjbxx.xb='2')or(vjbxx.yhzgx='64'andvjbxx.xb='1')or(vjbxx.yhzgx='66'andvjbxx.xb='2')o

7、r(vjbxx.yhzgx='67'andvjbxx.xb='1')or(vjbxx.yhzgx='71'andvjbxx.xb='2')or(vjbxx.yhzgx='72'andvjbxx.xb='1')or(vjbxx.yhzgx='73'andvjbxx.xb='2')or(vjbxx.yhzgx='74'andvjbxx.xb='1')or(vjbxx.yhzgx='75'andvjbxx.xb='1')or(vjbxx.yhzgx='76'andvjbxx.xb='2')or(vjbxx.yhzgx='77'a

8、ndvjbxx.xb='1')or(vjbxx.yhzgx='78'andvjbxx.xb='2')or(vjbxx.yhzgx='81'andvjbxx.xb='2')or(vjbxx.yhzgx='82'andvjbxx.xb='1')or(vjbxx.yhzgx='83'andvjbxx.xb='