SELECT *
FROM zcyj_20080406140017 a INNER JOIN
zcyj_20080406140017 b ON a.jtbh = b.jtbh AND a.dqzd = b.dqzd AND a.id <> b.id
FROM zcyj_20080406140017 a INNER JOIN
zcyj_20080406140017 b ON a.jtbh = b.jtbh AND a.dqzd = b.dqzd AND a.id <> b.id