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