Re: - Mailing list pgsql-general

From D. Dante Lorenso
Subject Re:
Date
Msg-id 3FF8C5FB.8060301@lorenso.com
Whole thread Raw
In response to  (<dimpyg@bsil.com>)
List pgsql-general
dimpyg@bsil.com wrote:

>Actually i have a problem, my problem is like this... i have a table A with
>one column, table B with one column and table C with one column. Now i want to
>create another table D which has all the three columns from table A, B,C.
>Could anyone plz help me regarding this.
>
>
That's easy to do.  Hard part is interpreting what you WANT.
You need to decide how you join table A, B, and C.  Are you
wanting table D like this:

 a | b | c
---+---+---
.. | ..| ..

or like this:

d
---
a
b
c

And, if the latter, how do you decide which rows in A match rows
in B and C?

You need to provide more information to be helped properly.

Dante



pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: PostgreSQL 7.4.1 incredibly slow :-(
Next
From: Carlos Moreno
Date:
Subject: Re: PostgreSQL 7.4.1 incredibly slow :-(