making two tables with identical schemas appear as one
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
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
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..
It depends on the specific way you want to bring the tables together.
Without more specific information nobody will be able to help.
Somehow I suspect you are looking for UNION:
CREATE VIEW
bothTables
AS SELECT
x, y, z
FROM tableA
UNION SELECT
x, y, z
FROM tableB
;
Mit freundlichem Gruß / With kind regards
Holger Klawitter
- --
lists <at> klawitter <dot> de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQFBJaMI1Xdt0HKSwgYRAkjQAJ95RawVA5ufaIaY1bITFHAvYsZWwACcCA0c
QKqsbAC1an/JIl/4Ok5mqLU=
=045v
-----END PGP SIGNATURE-----
Do you mean
create view MyView as
select * from table1
union
select * from table2;
John Sidney-Woollett
Otto Blomqvist wrote:
Show quoted text
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
On Fri, Aug 20, 2004 at 10:40:43AM +0100, John Sidney-Woollett wrote:
Do you mean
create view MyView as
select * from table1
union
select * from table2;
Be sure to understand the difference between UNION and UNION ALL if you
are going to do this ...
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No reniegues de lo que alguna vez cre�ste"