Re: view creation question

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