On Thu, Mar 09, 2006 at 10:55:12AM -0500, 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?
Use UNION or UNION ALL.
http://www.postgresql.org/docs/8.1/interactive/queries-union.html
--
Michael Fuhr