Re: SELECT from multiple tables (not join though)

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Madison Kelly <linux(at)alteeve(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT from multiple tables (not join though)
Date: 2005-01-10 17:47:50
Message-ID: 20050110174750.GA97656@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Madison Kelly 2005-01-10 17:47:53 Re: SELECT from multiple tables (not join though)
Previous Message Alex Turner 2005-01-10 17:44:54 Re: SELECT from multiple tables (not join though)