Re: a question on SQL - Mailing list pgsql-general

From Ragnar
Subject Re: a question on SQL
Date
Msg-id 1165943627.6369.49.camel@localhost.localdomain
Whole thread Raw
In response to a question on SQL  ("Tomi N/A" <hefest@gmail.com>)
List pgsql-general
On þri, 2006-12-12 at 16:47 +0000, Tomi N/A wrote:
> Don't really know where to ask this...the general mailing list sounds
> like the closest.
>
> Let's say I have three tables: owner, factory and product with a 1:N
> relationship at each step.
> Assuming that a product has a production date, how would you go about
> returning a factory for every owner, where the returned factory is the
> factory that produced the oldest product of it's owner?


> Hints?

someting like this maybe:
  select distinct on (owner.id,factory.factoryid) *
      from owner,factory,product
      where <your join contitions>
      order by owner.id,factory.factoryid,production_date

gnari




pgsql-general by date:

Previous
From: "Belinda M. Giardine"
Date:
Subject: Re: date comparisons
Next
From: "Marc Mamin"
Date:
Subject: Re: a question on SQL