MAX()
From: Anthony Pontier <apontier_at_hotmail.com>
Date: Tue, 30 Oct 2001 15:55:50 -0600
Message-ID: <6uFD7.54926$6i7.7453352_at_e420r-atl1.usenetserver.com>
Hello,
Date: Tue, 30 Oct 2001 15:55:50 -0600
Message-ID: <6uFD7.54926$6i7.7453352_at_e420r-atl1.usenetserver.com>
Hello,
[Quoted] I have a column in a table that I want to update from another table, the problem is the update from table has more than one row that matches the keys [Quoted] of my update to table, the update from table has a column that keeps track of the number of entries in this table for each set of keys from the update to table.
[Quoted] I want to update table1.col_A with the value in table2.col_B from the row that has the MAX(table2.col_Z).
Make sense ?
Thanks,
Tony P. Received on Tue Oct 30 2001 - 22:55:50 CET