"Peter Alberer" <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at> writes:
> Hmm, what about
>
> create view v1 as
> select *,1 as source from t1
> union
> select *,2 as source from t2;
And you might want "UNION ALL". Otherwise the database has to go eliminate
duplicate records (and there won't be any duplicate records with the "source"
column there anyways).
--
greg