select a.* FROM GEOB01 a join(
SELECT DISTINCT JHH=(JHH) FROM GA02 WHERE HS>10
)b on a.JHH=b.JHH
WHERE a.name1='kk'
SELECT DISTINCT JHH=(JHH) FROM GA02 WHERE HS>10
)b on a.JHH=b.JHH
WHERE a.name1='kk'
调试欢乐多
WHERE name1='kk'
AND exists (SELECT 1 FROM GA02 WHERE HS>10 and JHH=a.JHH)
from GEOB01 A
innner join
(SELECT DISTINCT (JHH)as jhh
FROM GA02
WHERE HS>10
) as
B on B.jhh=A.JHH
where A.name1='kk'
WHERE name1='kk' AND exists(SELECT DISTINCT (JHH) FROM GA02 WHERE HS>10 JHH=a.JHH)
SELECT DISTINCT JHH=(JHH) FROM GA02 WHERE HS>10
)b on TABL.JHH=b.JHH
WHERE TABL.name1='kk'SELECT * FROM GEOB01 TABL
WHERE name1='kk'
AND exists (SELECT DISTINCT(JHH) FROM GA02 WHERE HS>10 and JHH=TABL.JHH)