Larry White wrote:
I need a read only view that concatenates data from two tables. Basically
both tables would need a simple query like
Select name, description, date from Tasks;
Select name, description, date from Issues;
Is there some way to wrap these two independent queries in a "CREATE VIEW
myview AS" statement?
SELECT * FROM Tasks
UNION ALL
SELECT * FROM Issues;
HTH
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend