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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
