Re: Inner join ?

Jurriaan Themmen wrote:

> Hi,
>
> I have a table with the following structure:
>
> product (txt)
> material (txt)
> update (date)
> material_weight (num)
>
> Explanation:
>
> Every product consists of a few materials. Every time the composition of a
> product is changed, the material weights are updated.
>
> How do I query this table so that I get the most recent composition per
> product , i.e. product, material, max(update), material_weight ?
>
> Kind regards
>
> Jurriaan

My impression is that this is homework from a class so I will not give you the answer. Why do I think that? Because Oracle has no field types named "txt" and "num" and anyone really working with Oracle would not misstate column definitions.

The hint you do get however is this: You need a subquery.

Daniel Morgan Received on Mon Jul 01 2002 - 17:25:51 CEST