Re: making two tables with identical schemas appear as

Do you mean

create view MyView as
select * from table1
union
select * from table2;

John Sidney-Woollett

Otto Blomqvist wrote:

> Hello !
>
> I have a couple of tables with the same schema that I would like to
> query and view as one table. I looked into CREATE VIEW and FULL JOINs
> but still can't figure out a good (fast) way of doing this..
>
> Any ideas ?
>
> /Otto Blomqvist
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster