TABLE A  
-------------------------------------------
PART 		PO_NO		PRICE
A		123		3
A		124		4
B		125		10	
B		126		13
B		127		14


sQL SCRIPTS

(SELECT A.PART , MAX(A.PRICE)
FROM A
GROUP BT A.PART ) QUERY1



TABLE B
-----------------------------------------------
PART 		COST
A		0
B		7



Question

How to use QUERY1 TO UPDATE THE TABLE B .



RESULT

---------------------------------------

TABLE B
----------------------------------
PART              COST
A		  4
B                 14