Fill multiple fields through one INNER JOIN

From: "Peter Dawn" <petedawn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Fill multiple fields through one INNER JOIN
Date: 2007-01-29 06:12:53
Message-ID: 5dd88dab0701282212j90aaabfn32dac780468b09da@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

guys,

i have a table which contains 5 fields, of these 2 fields need to be
filled in through an inner join from one same table.

now i have managed to fill in one field using the inner join method.
but the second field also is exactly the same and needs to be filled
in from the same table, the only difference is the field name is
different and obviously the content of these two fields is also
different (but its still coming from the same other table).

so i guess my question is how do i populate two fields using an inner
join (both these fields contain different data but from the same
table). i hope i have been able to explain myself.

thanks.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Duncan Garland 2007-01-29 11:09:47 Re: 8.2.1 to_char(negative interval,'HH24:MI') bug?
Previous Message Frank Bax 2007-01-29 02:30:46 8.2.1 to_char(negative interval,'HH24:MI') bug?