PL/SQL Help??

From: <schmidm_at_kta95.com>
Date: Fri, 17 Nov 2000 20:20:01 GMT
Message-ID: <8v43t8$42d$1@nnrp1.deja.com>

I have two tables:
empl(...,email_id, cont_name_1, cont_name_2, cont_phone_1, cont_phone_2, cont_rel_1, cont_rel_2,...) kta_emerg(userid, contact, phone, relation,num)

I need to update the empl table values from the values in kta_emerg. Specifically, I need:
update empl set

  empl.cont_name_1=kta_emerg.contact,
  empl.cont_phone_1=kta_emerg.phone,
  empl.cont_rel_1=kta_emerg.relation

  where empl.email_id=kta_emerg.userid and kta_emerg.num='1'; update empl set

  empl.cont_name_2=kta_emerg.contact,
  empl.cont_phone_2=kta_emerg.phone,
  empl.cont_rel_2=kta_emerg.relation

  where empl.email_id=kta_emerg.userid and kta_emerg.num='2';

I know this isn't the proper syntax, but hopefully someone has a simple solution!

Thanks
MS

--
Martin Schmid
Applications Developer
KtaNet


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Fri Nov 17 2000 - 14:20:01 CST