Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT from multiple tables (not join though) - Mailing list pgsql-general

From Michael Fuhr
Subject Re: SELECT from multiple tables (not join though)
Date
Msg-id 20050110174750.GA97656@winnie.fuhr.org
Whole thread Raw
In response to SELECT from multiple tables (not join though)  (Madison Kelly <linux@alteeve.com>)
List pgsql-general
Tree view 
On Mon, Jan 10, 2005 at 12:22:41PM -0500, Madison Kelly wrote:

> What I need is to return all of the matches in all of the tables
> in a single column.

Maybe you're looking for UNION -- see the "Combining Queries" section
in the "Queries" chapter of the documentation.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Alex Turner
Date:
Subject: Re: SELECT from multiple tables (not join though)
Next
From: Madison Kelly
Date:
Subject: Re: SELECT from multiple tables (not join though)