difficult? sql statement

From: Johann Tinnacher <j-tinnacher_at_netway.at>
Date: 1998/01/12
Message-ID: <34BA7E39.27E5@netway.at>#1/1

hello everybody,

i've got two tables:

table a:

PARTNO WEIGHT DATA....

---

PART_1      100			A
PART_2      130			B
PART_2      134			C
PART_3      50			D

table b:

PARTNO WEIGHT DATA ...

---

PART_1		100			A
PART_2		130			B
PART_3		50			D

how do i update only the DATA of table b with the DATA of table of those rows from table a
where WEIGHT is the maximum of each PARTNO? is this possible?

thanks.

---

Johann Tinnacher
Posch Ges.m.b.H.

(j-tinnacher_at_netway.at) Received on Mon Jan 12 1998 - 00:00:00 CST