From: | "Duncan Garland" <duncan(dot)garland(at)ntlworld(dot)com> |
---|---|
To: | "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Fill multiple fields through one INNER JOIN |
Date: | 2007-02-06 18:31:54 |
Message-ID: | MBEPKEEDMKGCDODFKLPPIEJJDNAA.duncan.garland@ntlworld.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'll second that. I can't see what Peter's trying to do.
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Andrej Ricnik-Bay
Sent: 06 February 2007 17:47
To: Peter Dawn
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Fill multiple fields through one INNER JOIN
On 1/29/07, Peter Dawn <petedawn(at)gmail(dot)com> wrote:
> 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.
Personally I always find example data helpful to try and
understand what people want to achieve ....
Cheers,
Andrej
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2007-02-06 18:50:02 | Re: Fill multiple fields through one INNER JOIN |
Previous Message | Andrej Ricnik-Bay | 2007-02-06 17:46:54 | Re: Fill multiple fields through one INNER JOIN |