SQL Question

[Bart Pietercil]

Hi List, Ruslan

This query is not accepted by Valentina but explains what I want to do

update a set user_recid = u.recid FROM advita_import a
join tbl_users u on a.employee_id = u.hr_db_id;

some database accept this syntax but ok, so I considered making a view

But it seems valentina views are only readonly so that won't work  
either.

I know I can do this using subselects but just can't get my head  
around it. Probably just too late...

Suggestions ?

tia

Bart