Basic SQL join question - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Basic SQL join question
Date
Msg-id 3E39E8A8.7020001@mega-bucks.co.jp
Whole thread Raw
Responses Re: Basic SQL join question
Re: Basic SQL join question
Re: Basic SQL join question
List pgsql-general
Sorry for this simple question but I can't seem to get Postgres to do
what I want ...

I want to get the concatenation of 2 or more tables with absolutely
nothing in common. How can I do this?

For example

Table a:

   a
-----
  a1
  a2
  a3

Table b:

   b
-----
  b1
  b2

Table c:

   c
-----
  c1
  c2
  c3
  c4

What is the proper SQL to return:

   a |  b |  c
---------------
  a1   b1   c1
  a2   b2   c2
  a3        c3
            c4


Thanks,

Jc


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Weird query plans for my queries, causing terrible performance.
Next
From: Justin Clift
Date:
Subject: Re: text searching in postgres