Inner join ?
From: Jurriaan Themmen <j.themmen_at_draka.nl>
Date: Mon, 1 Jul 2002 07:35:53 +0200
Message-ID: <afoptf$h6s$1_at_reader06.wxs.nl>
Date: Mon, 1 Jul 2002 07:35:53 +0200
Message-ID: <afoptf$h6s$1_at_reader06.wxs.nl>
Hi,
I have a table with the following structure:
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
product (txt)
material (txt)
update (date)
material_weight (num)
Jurriaan Received on Mon Jul 01 2002 - 07:35:53 CEST