Views
•
A view is a virtual table
•
It is defined as the result of a subquery
•
CREATE VIEW sources
AS
SELECT
r.name, b.ra, b.dec,
r.mag rmag, b.mag bmag
FROM bsources b, rsources r;
•
View ‘sources’ with columns ‘name’, ‘ra’, ‘dec’,
‘rmag’ and ‘bmag’
A view is like an alias