In addition to the other replies (regarding UNION), are you aware that
you can use inheritance in postgres to factor out common fields ? Then
you could use the parent table to access the common denominator of the
children. I'm not sure though if this fits your needs, just worth
mentioning.
See also:
http://www.postgresql.org/docs/8.1/static/tutorial-inheritance.html
Cheers,
Csaba.
On Thu, 2006-03-09 at 16:55, 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?
>
>