Re: Update

Serra wrote:

> Isnt it possible something like below
> 
> UPDATE  T1  SET (F1, F2, F3, F4 )
> SELECT  F1, F2, F3, F4  FROM  T2

No. There is no way for the database server to know which row from the
select to match with a particular row in T1.  You can do:

UPDATE T1
SET AFIELD = (SELECT SOMEFIELD FROM T2 WHERE T2.PK = T1.PK)

The SELECT must return a single row.

-- 

IB 6,5

Isnt it possible something like below

UPDATE  T1  SET (F1, F2, F3, F4 )
SELECT  F1, F2, F3, F4  FROM  T2

Thank you.