Hi all...
I'm testing MonetDB and evaluating all functionality. One item I've not been able to find much info on is updating table A from table B. ie...
UPDATE PERSON
SET SALARY = sal.newval
FROM PERSON P, SAL_DATA sal
WHERE p.id = sal.p_id
Or something to that effect :) Is it possible?
Thanks
Cronje