Query:

select top 10
  objID, field.run, field.rerun, field.camcol, field.fieldId,
  obj, ra, dec, raErr, decErr, raDecCorr,
  offsetRa_u, offsetRa_g, offsetRa_r, offsetRa_i, offsetRa_z,
  offsetDec_u, offsetDec_g, offsetDec_r, offsetDec_i, offsetDec_z,
  u, g, r, i, z, err_u, err_g, err_r, err_i, err_z,
  mjd_u, mjd_g, mjd_r, mjd_i, mjd_z
from
  PhotoObjAll
join
  field
on (field.fieldId=PhotoObjAll.fieldId)