Hello everybody

I have the table MOVIMCAB (MVC_IDENTI, MVC_DATE)

The table MOVIMDET (MOV_IDENTI, MOV_PRODUCTCODE, MOV_COUNT)

The table PRODUCTS (PRD_CODE, PRD_COUNT)

And I want to update each column PRD_COUNT with the last MOV_COUNT

UPDATE PRODUCTS SET PRD_COUNT = the last MOV_COUNT

for each product code.

Thanks in advance.

Walter.


[Non-text portions of this message have been removed]