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’