Re: Update SQL problem

From: Ivars Grinbergs <ivars_at_power.it-riga.lv>
Date: 1996/01/24
Message-ID: <3106340E.67A1_at_power.it-riga.lv>#1/1

Hello,  

Peter Yates wrote:

> ...
> update table1
> set day=sysdate
> where table1.id = (select id from table2 where field2 like 'BLAH');
> ...
May be try to use 'in' instead of '=' in where condition!  

Sincerely
Ivars Grinbergs

---

IT Riga Ltd., Oracle distributor in Latvia, ph. +371-7220281 fax.+371-7820173

             address: 14-23 Puskina str., Riga, Latvia, LV1003 
             e-mail:  ivars_at_power.it-riga.lv 
------------------------------------------------------------------------------

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