Re: a question on SQL

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