日期:2014-05-17 浏览次数:20667 次
select s1,sfzhm ,xm,xb,csrq,''ryzp from page_person where s3=1 and sfzhm in (
select sfzhm from page_czrkgl_jtcy where gridconto in (
select gridconto from page_czrkgl_jtcy where s3=1 and sfzhm='320422196909204606' and hjbh='320400000000'
) and hjbh='320400000000'
)
SELECT s1 ,
sfzhm ,
xm ,
xb ,
csrq ,
'' ryzp
FROM page_person --409W
WHERE s3 = 1
AND sfzhm IN ( /*sfzhm 上建立索引*/
SELECT sfzhm
FROM page_czrkgl_jtcy --405W
WHERE gridconto IN ( SELECT gridconto /*gridconto 上建立索引*/
FROM page_czrkgl_jtcy
WHERE s3 = 1
AND sfzhm = '320422196909204606'
AND hjbh = '320400000000' )
AND hjbh = '320400000000' )
select pp.s1,pp.sfzhm ,pp.xm,xb,pp.csrq,''ryzp
from page_person pp
inner join page_czrkgl_jtcy pc on pp.sfzhm =pc.sfzhm
inner join page_czrkgl_jtcy pj on pc.gridconto=pj.gridconto and pp.s3=pj.s3
on pc.hjbh=pj.hjbh
where pp.s3=1 and pj.sfzhm='320422196909204606' and pc.hjbh='320400000000'