VIEW  TargetBulge

The TargetBulge view is the master target list of stars observed in the GES Bulge programme. For each star, in addition to the identifier and celestial coordinates, some summary parameters derived from analysis of the spectra are included for convenience. The bulge target list was defined by the GES Consortium.

SELECT
  target.*
FROM
  Target target,
  ProgrammeTarget progtar
WHERE
  target.targetID = progtar.targetID AND
  progtar.targetID = 1

The details of the table defined by this view are available here.