update tablexx from

From: Maggie <maggiezhou_at_hotmail.com>
Date: Mon, 20 Mar 2000 17:14:14 -0800
Message-ID: <8b6idc$jh$1@web1.cup.hp.com>

I ran the query but
update bcd
 set set b.cust_name=dr11.customer_nm
from bcd b, dr11_order_tmp dr11
where dr11.customer_nm='synnex

But I got
SQL> /
from bcd b,dr11_orders_tmp dr11
*
ERROR at line 3:
ORA-00933: SQL command not properly ended

---

Is there " from " after set in update in Oracle? Received on Mon Mar 20 2000 - 19:14:14 CST