VIEW  TargetHalo

The TargetHalo view contains the master target list of stars observed in the GES Halo programme.


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

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