--- find stars relevant to ECHOS objects
select po.dered_u, po.dered_g, po.dered_r, po.dered_i, po.dered_z,
       so.z, so.zerr, so.zConf, so.ra, so.dec, so.bestObjID,
       pm.pmRa, pm.pmDec, pm.pmRaErr, pm.pmDecErr
into mydb.echoPCII10 -- ECHOS PCII-10
-- into mydb.echoPCII11 -- ECHOS PCII-11
from SpecObjAll as so,
     PhotoObjAll as po left outer join ProperMotions as pm on po.objID = pm.objid
where so.bestObjID = po.objId
  and so.ra between 159.8 and 167.8 -- ECHOS PCII-10
  and so.dec between 46.0 and 50.0  -- ECHOS PCII-10
--  and so.ra between 125.6 and 133.6 -- ECHOS PCII-11
--  and so.dec between 51.9 and 55.9  -- ECHOS PCII-11
  and so.z < 0.002