Hmm, what about
create view v1 as
select *,1 as source from t1
union
select *,2 as source from t2;
>Hello list
>
>I have two tables with identical structure, one holds 'correct' data
(from
>an application standpoint) and the other has data 'in error'. Anyway, I
>need
>
Hello list
I have two tables with identical structure, one holds 'correct' data (from
an application standpoint) and the other has data 'in error'. Anyway, I need
sometimes to query both tables at the same time, so I constructed an
elementary view
create view v1 as select * from t1 union select *
