Home » SQL & PL/SQL » SQL & PL/SQL » UPDATE TABLE FROM ANOTHER
UPDATE TABLE FROM ANOTHER [message #1024] Thu, 21 March 2002 10:03 Go to next message
Antoni
Messages: 8
Registered: February 2002
Junior Member
Hi what's the problem in here? it says me:

The following error has occurred:

ORA-06550: line 21, column 2:
PLS-00103: Found "FROM" when looking for...

update productos_gescon t1
set
t1.ges_desc = t2.nombre1,
t1.ges_jer = t2.codigo_estadist,
t1.ges_ean_uni = t2.ean11_uc,
t1.ges_ean_caja = t2.ean11,
t1.ges_conlk = DECODE (t2.kilo_o_litro, 'K', t2.peso_neto, t2.volumen_neto),
t1.ges_uni_caja = t2.uvta_consumo,
t1.ges_pieza_caja = t2.piezas_por_caja
from eka_p_attrib_toni t2
where
t3.ges_codprod = to_number(substr(t1.producto, 1, length (t3.producto)-1))
and
t2.necesario_eureka = 'SI'
and
t2.tabla = 'MARA';
Re: UPDATE TABLE FROM ANOTHER [message #1027 is a reply to message #1024] Thu, 21 March 2002 15:00 Go to previous messageGo to next message
seng
Messages: 191
Registered: February 2002
Senior Member
you can't have this

from eka_p_attrib_toni t2

in your update statement. Hope this is helping.
Re: UPDATE TABLE FROM ANOTHER [message #1029 is a reply to message #1024] Thu, 21 March 2002 19:42 Go to previous message
nash
Messages: 10
Registered: February 2002
Junior Member
where t3.ges_codprod = to_number(substr(t1.producto, 1, length (t3.producto)-1))

--------------
Check the above statement, you will find the error.

--------------
HTH

nash
Previous Topic: Changing datatype
Next Topic: Using query results in next query...is it possible?
Goto Forum:
  


Current Time: Thu Mar 28 14:11:09 CDT 2024