| View of CurrentAstrometry table showing only VIDEO data |
| This view is just a select of CurrentAstrometry for the VIDEO and Calib programmes for access to pre-release data |
SELECT dbo.CurrentAstrometry.*
FROM dbo.CurrentAstrometry INNER JOIN dbo.ProgrammeFrame
ON dbo.CurrentAstrometry.multiframeID = dbo.ProgrammeFrame.multiframeID
WHERE dbo.ProgrammeFrame.programmeID = 150 OR
dbo.ProgrammeFrame.programmeID = 200
The details of the table defined by this view are available here.