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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
