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

Reply via email to