SQL Question

[Ruslan Zasukhin]

On 1/30/09 11:58 PM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:

> 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...

Can you explain in english task?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]