gdtech
Last Activity: Oct 23 '07, 01:22 PM
Joined: Oct 21 '07
Location:
-
Thanks - worked great -
Update Record With Min Values
I am trying to update all FIELDs in a TABLE where a condition of min COSTs exist. I currently have 6 rows in my table 2 are non unique when I query select for all min COSTs grouped by ITEM_NO I get 5 - correct. But when I run the update query I get all 6 rows affected.
/*WORKING SELECT QUERY*/
SELECT ITEM_NO , MIN(COST) AS LOWEST
FROM TABLE
GROUP BY ITEM_NO
/* INCORRECT UPDATE QUERY */
...
No activity results to display
Leave a comment: