Re: simple yet complex join

Hmmm, thanks for the pointer.
I think I'm going to take the easier road and program
my way through the problem with some perl iterations.

Thanks all!



Jeff Eckermann wrote:
> I think what you are looking for is a "pivot table"?
> This is not easy using SQL, but workarounds have been
> discussed several times in the past.  I suggest you
> search the archives for "pivot table", and you will
> find plenty of references.
>
> --- Vincent Stoessel <vincent@xaymaca.com> wrote:
>
>>Hello All,
>>I've been reading the archives, the manual and  my
>>sql books.
>>lack of sleep is making what seems easy very hard to
>>figure out
>>right now.
>>
>>what kind of join do I have to do in order to
>>combine 3 tables of
>>similiar information. For example 3 months' worth of
>>payments from
>>customers:
>>
>>
>>jan_pay
>>
>>
>>tom 25
>>ron 30
>>jim 0
>>
>>
>>feb_pay
>>
>>tom 25
>>ron 20
>>jim 10
>>
>>
>>march_pay
>>
>>tom 25
>>ron 30
>>jim 5
>>pat 40
>>
>>
>>
>>I want a result that looks like this :
>>
>>
>>tom 25 25 25
>>ron 30 20 30
>>jim  0 10  5
>>pat  0  0 40
>>
>>
>>
>>I've tried so many kinds of strage joins that I am
>>ashamed to post them
>>here. Can someone please light the candle?
>>Thanks in advance.
>>
>>
>>--
>>Vincent Stoessel
>>Linux Systems Developer
>>vincent xaymaca.com
>>
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>
>
>
> __________________________________________________
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com



--
Vincent Stoessel
Linux Systems Developer
vincent xaymaca.com