I am trying to update some fields in a table. But the condition for the update includes fields from other tables. Can some one please tell me what is wrong with this query. It says [1]: (Error): ORA-00933: SQL command not properly ended
update ctrn
set ctrn_cldt_clnt_id = 3002, ctrn_apply_code = 'O', ctrn_upadte_user= 'ISR3075'
from ctrn, audit_exceptions, audit_types
where ctrn_cldt_clnt_id = 3014
and ctrn_apply_code = 'H'
and ctrn_trnt_code = 'C'
and audx_audt_code = 7131
and ctrn_sid = AUDX_FOREIGN_KEY1
and AUDX_TABLE_ALIAS = 'CTRN'
and audx_audt_code = audt_code;
Thank you
update ctrn
set ctrn_cldt_clnt_id = 3002, ctrn_apply_code = 'O', ctrn_upadte_user= 'ISR3075'
from ctrn, audit_exceptions, audit_types
where ctrn_cldt_clnt_id = 3014
and ctrn_apply_code = 'H'
and ctrn_trnt_code = 'C'
and audx_audt_code = 7131
and ctrn_sid = AUDX_FOREIGN_KEY1
and AUDX_TABLE_ALIAS = 'CTRN'
and audx_audt_code = audt_code;
Thank you