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? > > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
