[Q:] SQL question

From: Johann Tinnacher <j-tinnacher_at_netway.at>
Date: 1998/01/15
Message-ID: <34BE708C.F1F@netway.at>#1/1

hello everybody!

i'm looking for a SQL-Statement. see my tables:

Table a  PARTNO     WEIGHT      DATA_A     DATA_B
         ========================================
         PART_01    10          aaa        bbb
         PART_02    12          aaaa       bbbb
         PART_02    14          02020202   02020202
         PART_03    12          s          xxx

Table b  PARTNO     DATA_A      DATA_B
         =============================
         PART_01
         PART_02
         PART_03

The script should update columns within table b with DATA_x of table a where WEIGHT ist max. WEIGHT of each PARTNO

table b should be:

PARTNO DATA_A DATA_B

---

PART_01     aaa          bbb
PART_02     02020202     02020202
PART_03     s            xxx

how should i do that?

many thanks.

---

Johann Tinnacher
Posch Ges.m.b.H.

(j-tinnacher_at_netway.at) Received on Thu Jan 15 1998 - 00:00:00 CST