Insert statement involving outer join [message #38862] |
Wed, 22 May 2002 07:32 |
Toyn
Messages: 36 Registered: April 2001
|
Member |
|
|
update orders_test set (ord_stat)=
(select code_dscr from ed_order_codes a, temp_ed_orders b
where a.code(+)=b.trans_code
and where exists (select null from orders_test c
where b.order_num=c.order_num));
I want to update a column in the orders_test table using an outer join to a dictionary I created (ed_order_codes). I want this update performed using the order_num from tables b and c. I get a 'missing expression' error when I use the 'and where' clause...what am I missing, or how should I restructure the statement to include all 3 tables? Thanks.
|
|
|
|