Re: Update SQL problem

Hi !
The simplest way would be :

update table1

    set day=sysdate
    where table1.id = (select id from table2 where field2 like'BLAH'

                               and rownum = 1);

Manisha Handa Received on Wed Jan 24 1996 - 00:00:00 CET