| Spectrum and SpecFrame combination |
| Extended details for each spectrum: all the columns from table 'Spectrum' combined with some columns from its parent 'SpecFrame'. |
SELECT sp.*, frame.instrument, frame.grating, frame.gesType, frame.object
FROM Spectrum sp,
SpecFrame frame
WHERE sp.specFrameId = frame.specFrameId
The details of the table defined by this view are available here.