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