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
