| WISE_xmatch | PHOTO | Astrometric cross-matches between SDSS and WISE objects.
This is a 'join table' which contains 'pointers' to the matched objects in the SDSS and WISE tables. The SDSS objects appear in the PhotoObjAll, PhotoObj,and PhotoTag tables. The WISE objects appear in the WISE_allsky table. Eg, to get r- and W1-band magnitudes of matched objects: 'select s.psfmag_r as r, w.w1mpro as w1 from wise_xmatch as xm join photoObjAll as s on xm.sdss_objid = s.objid join wise_allsky as w on xm.wise_cntr = w.cntr' |
