Re: Help me with this tricky join

From: Jay <josip(dot)2000(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help me with this tricky join
Date: 2010-03-20 09:10:39
Message-ID: 73afbd54-984f-4116-8069-35b621010eab@j21g2000yqh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks!
But, since the master can contain many users (user2, user3, and so on)
I suppose this won't be a proper solution?
Sorry if I was a bit unclear in my description.

I.e., the master is of the form:

user_id date
User1 20010101
User1 20000101
User1 19990101
User1 19970101
User2 ...
...

Btw, I'm using Postgre version 8.2 and I cannot use subqueries do the
GP software.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-03-20 09:26:13 Re: Transaction table
Previous Message Deepa Thulasidasan 2010-03-20 08:47:51 Transaction table