VIEW  TargetOpen

The TargetOpen view contains the master target list of stars observed in the GES open cluster programme.


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

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