SELECT TOP 10000
     p.objid,p.ra,p.dec,p.u,p.g,p.r,p.i,p.z,
     p.run, p.rerun, p.camcol, p.field,
     s.specobjid, s.class, s.z as redshift,
     s.plate, s.mjd, s.fiberid
FROM PhotoObj AS p
     JOIN SpecObj AS s ON s.bestobjid = p.objid
WHERE
     s.class='STAR'
     AND p.b >20